Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_JOB possible bug in Oracle Server 8.1.5 ?

Re: DBMS_JOB possible bug in Oracle Server 8.1.5 ?

From: Tom Davis <tom.davis_at_autotrader.com>
Date: 15 Aug 2001 13:34:44 -0700
Message-ID: <df010c89.0108151234.6a1a5963@posting.google.com>


Luis,

You're using the incorrect date format for minutes. Month can be formatted with an "mm" (like 12 for December, etc.), so that's why you're getting the error--because you already are defining month with "MON". Use "HH" for hours and "MI" for minutes, and you should be OK.

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:MI
AM'));
4 end;
5 /

lcnobre_at_americel.com.br (Luis Nobre) wrote in message news:<72646b0e.0108150543.2f2aef02_at_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!!
>
>
>
Received on Wed Aug 15 2001 - 15:34:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US