Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> DBMS_JOB.SUBMIT error

DBMS_JOB.SUBMIT error

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Wed, 01 Dec 1999 18:43:55 GMT
Message-ID: <38456b75.79345933@news.earthlink.net>


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 email

Received on Wed Dec 01 1999 - 12:43:55 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US