SQL & PL/SQL

Hi

I need to create a parallel execution of a procedure, I tried the way below

DECLARE

c_task_name CONSTANT VARCHAR2(128) := 'MYJOB';

BEGIN

 BEGIN

   DBMS\_PARALLEL\_EXECUTE.DROP\_TASK(c\_task\_name);

 EXCEPTION 

    WHEN OTHERS THEN 

       NULL;  

 END;  

dbms_parallel_execute.create_task(c_task_name);

dbms_parallel_execute.create_chunks_by_sql (task_name => c_task_name

                                        , sql\_stmt  => q'$ select distinct

                                                                  audsid

                                                                , audsid

                                                             from V$SESSION WHERE ROWNUM \<=10 $'

                                        , by\_rowid  => FALSE);

dbms_parallel_execute.run_task (task_name => c_task_name

                            , sql\_stmt       => q'$ 'begin MYPROCEDURE(TRUE, 'G'); end;' $'

                            , language\_flag  => DBMS\_SQL.native

                            , parallel\_level => 5);

--dbms_parallel_execute.drop_task(c_task_name);

END;

But when I did Select in dba_parallel_execute_chunks return me

How can I do It Start 9 instance of a procedure, since it does several processing and I do not know if I could put the rowid of a table