Thanks, Tom!!!
tom.davis_at_autotrader.com (Tom Davis) wrote in message news:<df010c89.0108151234.6a1a5963_at_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 Thu Aug 16 2001 - 21:32:08 CDT
