SQL & PL/SQL

Hi All,

Currently I’m facing an issue with the method of DBMS_PARALLEL_EXECUTE.run_task can't work well if the Parallel_LEVEL value set great than 1, the statement like below:

DBMS_PARALLEL_EXECUTE.run_task(task_name      => c_task_name,

sql_stmt => c_code_block,

language_flag   => DBMS_SQL.NATIVE,

parallel_level   => 4);

If parallel_level value set great than 1, the program will hold at this statement, like dead, I don't know if some parameters related on this need to setting, so anyone can give me some suggestion on this,  will be very grateful.

Thanks,

Kevin Lee