OraFAQ Forum: SQL & PL/SQL » Executing procedures in parallel

Home » SQL & PL/SQL » SQL & PL/SQL » Executing procedures in parallel (Any)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Executing procedures in parallel [message #620499]

Sun, 03 August 2014 09:42

km88
Messages: 3
Registered: March 2014
Location: Hyderabad

Junior Member

Hi all,
Is it feasible in Pl/sql to execute one or more procedures in parallel.

Ex: Create or Replace procedure CALL_PROCS AS
BEGIN
PROCEDURE1('A');
PROCEDURE1('B');
PROCEDURE1('C');
PROCEDURE1('D');
END;
/

I want to call the above procedures in CALL_PROCS at one go, not in serial execution.

Any suggestion is highly appreciated.

Thanks in advance,
MK

Report message to a moderator

Re: Executing procedures in parallel [message #620500 is a reply to message #620499]

Sun, 03 August 2014 09:52

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Call them through using dbms_job or dbms_scheduler.

Report message to a moderator

Re: Executing procedures in parallel [message #620501 is a reply to message #620500]

Sun, 03 August 2014 10:08

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and read http://www.orafaq.com/forum/t/174502/

Report message to a moderator

Re: Executing procedures in parallel [message #620504 is a reply to message #620499]

Sun, 03 August 2014 10:29

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Its one of the common interview questions.

Anyway,as Michel already suggested, see this link to docs http://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_sched.htm

Report message to a moderator

Previous Topic:	how to select data from subpartition table
Next Topic:	Dynamic Column Generation by using pivot

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 10 01:24:44 CDT 2024