DBMS_JOB.SUBMIT problem
Date: Fri, 2 Feb 2001 22:18:14 -0000
Message-ID: <LlGe6.771$i54.979368_at_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:
:= . ( _at_ % ;
CREATE OR REPLACE PROCEDURE submit_random_job
IS
BEGIN
dbms_output.ENABLE;
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
lv_job BINARY_INTEGER;
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 - 23:18:14 CET