|
|
| Purpose |
|
To inform Migration Engineers of the correct procedure for executing multiple DML statements as a single statement.
|
| Scope & Application |
|
The audience for this document is Oracle Customers, Oracle Partners and Oracle Migration Specialists.
|
| Multiple Non-Query DML Statements Executed As A Single Statement |
When you see a number of statements executed as one statement, you need to wrap the statements inside an anonymous block. Change the string to the following format:
1. Insert a “BEGIN ” before the first statement
2. End each statement with a ‘;’
3. After the last statement insert “ END; “
|
| Before |
After |
Str = "insert into #temp_BC "
+ "select * from DQ_FeedSystems "
+ "delete #temp_BC ";
|
Str = "BEGIN “
+ “delete tt_java_temp_BC; "
+ " insert into tt_java_temp_BC select * from DQ_FeedSystems "
+ " delete tt_java_temp_BC; “
+ “ END;";
|
|
|
|
|
Bookmark
