Error in DBMS_JOB.SUBMIT
AbkSep 6 2010 — edited Sep 6 2010Dear All,
I am getting erron when submitting job in oracle 9.2 database. pl help me to submit the job. job need to be executed on every day 5pm.
BEGIN
SYS.DBMS_JOB.SUBMIT
(
NOB => 12
,what => 'SYS.PR_STATUS;'
,next_date => 'trunc(sysdate)+1+(17*60)/(24*60)'
,interval => 'TRUNC(SYSDATE+1)'
);
END;
error Information
------------------------
Error starting at line 36 in command:
BEGIN
SYS.DBMS_JOB.SUBMIT
(
NOB => 12,
what => 'SYS.PR_STATUS;'
,next_date => 'trunc(sysdate)+(1020/1440)'
,interval => 'TRUNC(SYSDATE+1)'
);
END;
Error report:
ORA-06550: line 2, column 1:
PLS-00306: wrong number or types of arguments in call to 'SUBMIT'
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
06550. 00000 - "line %s, column %s:\n%s"
*Cause: Usually a PL/SQL compilation error.
*Action:
Thanks and regards,
Abk.