Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> DBMS_JOBS problem
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);