| bulk collect [message #575043] |
Fri, 18 January 2013 06:00  |
xpact83
Messages: 203
Registered: October 2008
Location: philippines
|
Senior Member |
|
|
I have procedure that has bulk collect and for all insert for about 14 tables and at that the last part of the procedure i call another procedure that will delete the records from the source table. my question is about the execution of code, will the procedure wait to finish processing of the bulk collect and for all insert before it will execute deletion?
here is the procedure body
begin
bulk collect and for all insert codes
call procedure to delete (will this code iexecutes even if the bulk collect code
is still running?)
end;
|
|
|
|
| Re: bulk collect [message #575044 is a reply to message #575043] |
Fri, 18 January 2013 06:23  |
cookiemonster
Messages: 9135
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
|
Bulk collect and forall are no different to any other pl/sql or sql command in this regard. The next command can not be run until the previous command has finished.
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
