Hi all,

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

20:28:16 Info: Job #16 could not be executed. ORA-12011: execution of 1 jobs failed
ORA-06512: at "SYS.DBMS_IJOB", line 469
ORA-06512: at "SYS.DBMS_JOB", line 282
ORA-06512: at line 1

  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); 
  DBMS_JOB.SUBMIT(ln_dummy,'MY_PROC_1('''|| p_stdate ||''','''|| p_edate ||''','''|| p_cdate||''','''|| p_key ||''', :p_ercode, :p_erdesc: );'); 
p_ercode and p_erdesc is an out parameter in MY_PROC_1. If i try to comment it out the job runs without an issue.
My question is how can i run the job without commenting out p_ercode and p_erdesc in MY_PROC_1.

Also, is there a way to know which job is running and which job is already done? something like an alert?

Appreciate your inputs. Thank you very much