Home » SQL & PL/SQL » SQL & PL/SQL » bulk collect (11g)
bulk collect [message #575043] Fri, 18 January 2013 06:00 Go to next message
Messages: 225
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

     bulk collect and for all insert codes
     call procedure to delete (will this code iexecutes even if the bulk collect code 
                                          is still running?)
Re: bulk collect [message #575044 is a reply to message #575043] Fri, 18 January 2013 06:23 Go to previous message
Messages: 12768
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: Sun Jun 25 14:15:47 CDT 2017

Total time taken to generate the page: 2.93524 seconds