running procs concurrently [message #425682] |
Sun, 11 October 2009 14:16  |
anurag42003
Messages: 1 Registered: October 2009 Location: KOLKATA
|
Junior Member |
|
|
Hi,
I want to have a proc A with two procs in it - B & C whom(B & C) I wanna run concurrently and wanna run proc D (D within proc A only ) at the completion of both proc B & C . Please suugest how can I do that .
|
|
|
|
Re: running procs concurrently [message #425835 is a reply to message #425682] |
Mon, 12 October 2009 07:37  |
 |
Kevin Meade
Messages: 2103 Registered: December 1999 Location: Connecticut USA
|
Senior Member |
|
|
plsql does not offer any "concurrent jobs" capability. this has been on open oracle TAR as a "Request for Enhancement" for years. don't expect it any time soon.
You will have to use the features are desribed by Michel et.al. and it is not at all efficient done this way so if you are thinking of doing this because you want to gain speed then unless the jobs your are spawning and running concurrently are long, you can forget it.
Makes me pine for the old DEC days when they offered this capability in their COBOL.
Good luck, Kevin
|
|
|