Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
I have a situation where I want to execute three Oracle stored procedures in parallel from a UNIX script. From my current testing I can't execute the stored procedure in parallel - only in sequence. I know that it can be done using the DBMS_JOB utlility in Oracle from a single stored procedure though would like to steer clear if possible.
Does anyone have any experience performing a task like this ? Can it be done within the same script or must it be carried out by executing three completely seperate statements ?
Name: Erick Date: August 10, 2001 at 06:02:48 Pacific
Reply:
Oracle enables to execute several time the same procedure (in the same time).Of course your PL/SQL procedure must manages the Lock table or record . But if you just make 'select' there is no problem with the parallele procedure call.
But this the Oracle behaviour. Sorry but I don't know what append when you call the procedure through Unix.
Summary: Please anyone can help here. How to compile PL/SQL stored procedures in system dictionary either using SQL Plus application in NT or command line in Unix envirnment. Then execute stored procedures fro...
Summary: Hi, I wud like to execute a unix script from a stored procedure at some step. please advise on how to do this. thanks for your help. Regards, Jern ...
Summary: I am trying to pass variables from a korn script to an oracle stored procedure that sends email. However when I pass the subject or the body of the email to the sql script that calls the procedure, e...
0 
