Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> DBMS_JOB.SUBMIT error
I tried submitting a job and got an error. I've been using an example
from PL/SQL book
SQLWKS> variable v_job_num number
SQLWKS> execute dbms_job.submit(:v_job_num, 'refresh_snap_f', sysdate,
'trunc(sysdate) + 31/24')
ORA-06550: line 1, column 108: 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 71 ORA-06512: at "SYS.DBMS_JOB", line 121 ORA-06512: at line 2
so I tried this
begin
dbms_job.submit(:v_job_num, 'refresh_snap_f', sysdate, 'trunc(sysdate)
+ 31/24');
end;
/
I also trying re-running dbmsjob.sql from $ORACLE_HOME/rdbms/admin, but it didn't help.
Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 373-5417 AOL: NetComrade ICQ: 11340726 remove NSPAM to emailReceived on Wed Dec 01 1999 - 12:43:55 CST