From: "Jeremy Ovenden" <jovenden@hazelweb.co.uk>
Newsgroups: comp.databases.oracle.server
Subject: Re: DBMS_JOBS problem
Date: Fri, 2 Feb 2001 22:57:38 -0000
Organization: Posted via Supernews, http://www.supernews.com
Message-ID: <t7memm66hebu55@xo.supernews.co.uk>
References: <fiGe6.770$i54.979131@newsr1.u-net.net>
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
X-Complaints-To: abuse@xo.supernews.co.uk
Lines: 30



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