Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Parallelize procedure call

2785725Nov 3 2014 — edited Nov 4 2014

Is there a simple way to make a parallel procedure call?

I wan't something like this:

declare

  l_first int;

  l_second int;

  l_third int;

begin

  l_first := start_new_thread('call my_procedure(1)'); 

  l_second := start_new_thread('call some_procedure(2)');

  l_third := start_new_thread('call some_procedure(3)');

 

  join_thread(l_first);

  join_thread(l_second);

  join_thread(l_third):

end;

The variant when you create task, create chunks, run task and after all you drop task it's not convenient I'm just want to run my procedure in new thread, i don't need chunk some table by rowid or something else.

This post has been answered by Billy Verreynne on Nov 4 2014
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 2 2014
Added on Nov 3 2014
5 comments
1,825 views