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.