Re: DBMS_JOB.SUBMIT problem

From: Matt Foster <matt_foster_uk_at_yahoo.co.uk>
Date: Sat, 03 Feb 2001 10:38:31 +0000
Message-ID: <3A7BDFA7.10AEDBA2_at_yahoo.co.uk>


RS wrote:
>
> 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:
>
> := . ( _at_ % ;
> 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;
You need to enter the what parameter as if you were running it from a PL/SQL block yourself. i.e.,
DBMS_JOB.SUBMIT(lv_job,'GENERATE_RANDOM_STAT;',sysdate,'sysdate+1/24');

HTH, MF

-- 
matt_foster_uk_at_yahoo.co.uk IS a valid address but very rarely looked at.
If you wish to respond privately please use matt.foster_at_ed.ac.uk
Received on Sat Feb 03 2001 - 11:38:31 CET

Original text of this message