From: "RS" <rs@rshome.u-net.com>
Newsgroups: comp.databases.oracle.server
References: <fiGe6.770$i54.979131@newsr1.u-net.net> <t7memm66hebu55@xo.supernews.co.uk>
Subject: Re: DBMS_JOBS problem
Lines: 36
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2615.200
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
Message-ID: <84He6.772$i54.980141@newsr1.u-net.net>
Date: Fri, 2 Feb 2001 23:07:43 -0000
NNTP-Posting-Host: 195.102.200.120
X-Complaints-To: news@u-net.net
X-Trace: newsr1.u-net.net 981155204 195.102.200.120 (Fri, 02 Feb 2001 23:06:44 GMT)
NNTP-Posting-Date: Fri, 02 Feb 2001 23:06:44 GMT


Thanks, it worked.

Jeremy Ovenden <jovenden@hazelweb.co.uk> wrote in message
news:t7memm66hebu55@xo.supernews.co.uk...
>
> "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
>
>
>
>