Re: DBMS_JOB possible bug in Oracle Server 8.1.5 ?

From: Luis Nobre <lcnobre_at_americel.com.br>
Date: 15 Aug 2001 06:43:09 -0700
Message-ID: <72646b0e.0108150543.2f2aef02@posting.google.com>

Well, i can tell you that i've worked "by the book". Here is what happens:

SQL> variable jobno number;
SQL> begin
  2 dbms_job.submit(:jobno,'PROC_1STCALLPRE(''01-07-2001'',''01-08-2001'');',

  3                     TO_DATE('16-AUG-2001 04:00','DD-MON-YYYY hh:mm AM'));

  4 end;
  5 /
begin
*
ERROR at line 1:
ORA-01816: month may only be specified once ORA-06512: at line 2

I've tried other things too but unsuccessfully. Could anyone give me a hand?
Thanks!!

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:<3b7a35bf$0$8505$ed9e5944_at_reading.news.pipex.net>...
> I'd also recommend the O'Reilly book Oracle Built-In Packages. I don't have
> the (or know if there is a) 8i version but it is a great reference.
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> "Galen Boyer" <galenboyer_at_hotpop.com> wrote in message
> news:upu9x7u26.fsf_at_verizon.net...
> > On 14 Aug 2001, lcnobre_at_americel.com.br wrote:
> >
> > > Does anybody know if there is a problem with the
> > > DBMS_JOB.SUBMIT? The oracle server version is 8.1.5.
> >
> > Do you have an error, or have you been told to use it and haven't
> > read anything about it?
> >
> > Go here, search, "DBMS_JOB" and read up on it.
> >
> >
> http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.817/
> a76936/toc.htm
> >
> > --
> > Galen Boyer
> > It seems to me, I remember every single thing I know.
Received on Wed Aug 15 2001 - 08:43:09 CDT