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 -> Problem with dbms_job

Problem with dbms_job

From: <silnet_at_ccn.it>
Date: Tue, 23 Feb 1999 08:02:23 GMT
Message-ID: <7atnab$olu$1@nnrp1.dejanews.com>


I can't understand why this don't work. Can someone help me?
Thanks in advance.

Massimo Pandolfo

SVRMGR> variable x number;
SVRMGR> begin
     2> dbms_job.submit(:x, 'prova_snp(''xxx'')', sysdate, 'sysdate+1');
     3> end;
     4> /

ORA-06550: line 1, column 110:
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

SVRMGR> -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Feb 23 1999 - 02:02:23 CST

Original text of this message

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