Home » SQL & PL/SQL » SQL & PL/SQL » bulk collect (11g)
bulk collect [message #575043] Fri, 18 January 2013 06:00 Go to next message
xpact83
Messages: 218
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 Go to previous message
cookiemonster
Messages: 11285
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.
Previous Topic: Compilation Issue
Next Topic: Employee summary
Goto Forum:
  


Current Time: Thu Dec 18 12:02:16 CST 2014

Total time taken to generate the page: 0.11126 seconds