Home » SQL & PL/SQL » SQL & PL/SQL » running procs concurrently (Oracle 9i)
running procs concurrently [message #425682] Sun, 11 October 2009 14:16 Go to next message
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 #425683 is a reply to message #425682] Sun, 11 October 2009 14:19 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Use DBMS_JOB to launch the procedures in parallel and DBMS_ALERT or DBMS_LOCK to synchronize.

Regards
Michel

[Updated on: Sun, 11 October 2009 14:19]

Report message to a moderator

Re: running procs concurrently [message #425835 is a reply to message #425682] Mon, 12 October 2009 07:37 Go to previous message
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
Previous Topic: Excel generation from oralce
Next Topic: similar plsql function to BigDecimal java function
Goto Forum:
  


Current Time: Thu Feb 13 17:17:14 CST 2025