CODEWITHSUNDEEP
sqloracle-databasestored-procedures
y2j
y2j

Reputation: 207

insert values coming from different procedure which will run parellely to a table in plsql

I m using Procedure1 and Procedure2 which will give me values a,b,c and d,e,f respectively.

Procedure1 and Procedure2 will run parallelarly and i want to insert these values in in a table (TABLE1) using the Procedure3.

Plz any one can tell me how i can do this .

Upvotes: 1

Views: 63

Answers (2)

Rusty
Rusty

Reputation: 2138

Probably you need to make procedure3 accepting input array, in procedure1 and procedure2 you will populate local variable of this array with your values and then simply call procedure3 passing array.

If you want to call them in parallel in oracle then you need to put them into JOB (see DBMS_SCHEDULER_JOB).

Upvotes: 1

vecio88
vecio88

Reputation: 95

You can try with autonomus transaction http://docs.oracle.com/cd/B19306_01/appdev.102/b14261/autonotransaction_pragma.htm

But I'm not sure that the two processes are executed at the same time

Upvotes: 1

Related Questions