|
|
| Purpose |
|
To inform migration specialists of the correct procedure for the removal of spurious BEGIN .. END statements.
|
| Scope & Application |
|
The audience for this document is Oracle customers, Oracle partners and Oracle staff.
|
| Remove Spurious BEGIN .. END Statements |
|
The T_SQL parser in the Oracle Migration Workbench produces spurious BEGIN .. END statements. It ensures correctness but it makes the code
very hard to read and maintain. Most of the BEGIN END statements can be removed. They are only really necessary when used with an appropriate EXCEPTION statement.
|
| Before |
After |
IF StoO_selcnt != 0 THEN
BEGIN
raise_application_error(-20999, 'Hello');
END;
END IF;
|
IF StoO_selcnt != 0 THEN
raise_application_error(-20999, 'Hello');
END IF;
|
|
|
|
|
Bookmark
