How to pass DATE parameter to a DBMS_JOB package
create or replace procedure proc_day as
l_job number ;
begin
dbms_job.submit(l_job,'pro_duration_alarms_daily(''05/09/2012'') ;');
dbms_job.submit(l_job,'pro_duration_alarms_daily(''05/10/2012'') ;');
dbms_job.submit(l_job,'pro_duration_alarms_daily(''05/11/2012'') ;');
COMMIT;
end;
while calling the above job procedure it give the following error message , what is wrong here
ERROR at line 1:
ORA-06550: line 1, column 93:
PLS-00306: wrong number or types of arguments in call to
'PRO_DURATION_ALARMS_DAILY'
ORA-06550: line 1, column 93:
PL/SQL: Statement ignored
ORA-06512: at "SYS.DBMS_JOB", line 82
ORA-06512: at "SYS.DBMS_JOB", line 140
ORA-06512: at "ORPHEUSNZ.PROC_DAY", line 4
ORA-06512: at line 1
What is wrong here..? in normal case I am calling the procedure as below
exec pro_duration_alarms_daily('05/09/2012') ;