Re: DBMS_JOBS problem

From: Jeremy Ovenden <jovenden_at_hazelweb.co.uk>
Date: Fri, 2 Feb 2001 22:57:38 -0000
Message-ID: <t7memm66hebu55@xo.supernews.co.uk>

"RS" <rs_at_rshome.u-net.com> wrote in message news:fiGe6.770$i54.979131_at_newsr1.u-net.net...
>
> 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;
>
>

Put a ; after your procedure name.
DBMS_JOB.SUBMIT (lv_job,'GENERATE_RANDOM_STAT;',...........

Jeremy Received on Fri Feb 02 2001 - 16:57:38 CST