Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_JOBS problem
try wrapping the procedure call in begin end; so dbms_job(lv_job,'begin generate_random_job; end;' etc...
Hth,
Sybrand Bakker, Oracle DBA
"RS" <rs_at_rshome.u-net.com> wrote in message
news:fiGe6.770$i54.979131_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:
> 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:50:52 CST