Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_JOB possible bug in Oracle Server 8.1.5 ?
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;
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