plsql - How to setup dbms_job with out parameter -

plsql - How to setup dbms_job with out parameter -

i'm trying run procedures in parallel using dbms_jobs i'm having issues doing it. when trying run below code, i'm getting error

20:28:16 info: job #16 not executed. ora-12011: execution of 1 jobs failed ora-06512: @ "sys.dbms_ijob", line 469 ora-06512: @ "sys.dbms_job", line 282 ora-06512: @ line 1 declare ln_dummy number; p_stdate constant date := '01-may-2012'; p_edate constant date := '31-may-2012'; p_cdate constant date := '09-feb-2013'; p_key constant integer:= 0; p_ercode integer; p_erdesc varchar2(200); begin commit; dbms_job.submit(ln_dummy,'my_proc_1('''|| p_stdate ||''','''|| p_edate ||''','''|| p_cdate||''','''|| p_key ||''', :p_ercode, :p_erdesc: );'); commit; end; /

p_ercode , p_erdesc out parameter in my_proc_1. if seek comment out job runs without issue.

my question how can run job without commenting out p_ercode , p_erdesc in my_proc_1.

also, there way know job running , job done? alert?

maybe, work?

declare ln_dummy number; p_stdate constant date := '01-may-2012'; p_edate constant date := '31-may-2012'; p_cdate constant date := '09-feb-2013'; p_key constant integer:= 0; begin commit; dbms_job.submit(ln_dummy,' declare p_ercode integer; p_erdesc varchar2(200); begin my_proc_1('''|| p_stdate ||''','''|| p_edate ||''','''|| p_cdate||''','''|| p_key ||''', p_ercode, p_erdesc ); end; '); commit; end;

plsql oracle10g