dbms_job.submit giving me error
I am trying to set up a job using dbms_job but I am getting an error I can't figure out. The dbms_job package is valid.
SQL>exec dbms_job.submit(:n1, 'LMT_Gather_Ts_Data', sysdate, 'sysdate + 1');
BEGIN dbms_job.submit(:n1, 'LMT_Gather_Ts_Data', sysdate, 'sysdate + 1'); END;
ERROR at line 1:
ORA-06550: line 1, column 112:
PLS-00103: Encountered the symbol "END" when expecting one of the following:
:= . ( @ % ;
The symbol ";" was substituted for "END" to continue.
ORA-06512: at "SYS.DBMS_JOB", line 79
ORA-06512: at "SYS.DBMS_JOB", line 131
ORA-06512: at line 1
Since dbms_job is a wrapped package, I'm unable to see the actual code. The version of the Database is 18.104.22.168.0
Last edited by gram2000; 08-12-2003 at 01:01 PM.
Click Here to Expand Forum to Full Width