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

Home -> Community -> Usenet -> c.d.o.tools -> DBMS_JOB.SUBMIT problem

DBMS_JOB.SUBMIT problem

From: RS <rs_at_rshome.u-net.com>
Date: Fri, 2 Feb 2001 22:18:14 -0000
Message-ID: <LlGe6.771$i54.979368@newsr1.u-net.net>

Can anyone tell me why the following code generates a run-time error (replies to rs_at_rshome.u-net.com please)...

ORA-06550: line 1, column 114:
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 72
ORA-06512: at "SYS.DBMS_JOB", line 140
ORA-06512: at "RJS.SUBMIT_RANDOM_JOB", line 9
ORA-06512: at line 2


CREATE OR REPLACE PROCEDURE submit_random_job IS
  lv_job BINARY_INTEGER;

BEGIN      dbms_output.ENABLE;

     DBMS_JOB.SUBMIT (lv_job,'GENERATE_RANDOM_STAT',
                      SYSDATE,
                      'sysdate + 1/24');
     COMMIT;

     dbms_output.put_line (lv_job);

END; Received on Fri Feb 02 2001 - 16:18:14 CST

Original text of this message

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