Re: DBMS_JOB question - BINGO

BINGO !
Thank You, Dirk, it was the semicolon missing ! (It was likely to be something silly like this ... )

Kind Regards,
Jan=)

"Dirk Tschentscher" <dirk.tschentscherREM_at_THISvolkswagen.de> schrieb im Newsbeitrag news:arvscm$rnm3_at_doiweb4.volkswagen.de...
> Hi Jan,
> I tried
> create or replace procedure job_start as
> jobno number;
> BEGIN
> DBMS_JOB.SUBMIT(jobno,
> 'sys.jg_load_objects', --an SP that has already been
> testedsuccessfully
> SYSDATE,
> 'SYSDATE + 1/48' --every half an hour
> );
> END;
>
> it works fine...
> but I think you need a ";" after "sys.jg_load_objects"
>
> Rgds
> Dirk
>
> "Jan Gelbrich" <j_gelbrich_at_westfalen-blatt.de> schrieb im Newsbeitrag
> news:arvrqn$m9q0u$1_at_ID-152732.news.dfncis.de...
> > Hello, folks,
> >
> > I maybe a complete blind fish, but why the heck wont the folowing
compile
> ?
> >
> > DECLARE
> > jobno number;
> > BEGIN
> > DBMS_JOB.SUBMIT(jobno,
> > 'sys.jg_load_objects', --an SP that has already been tested
> > successfully
> > SYSDATE,
> > 'SYSDATE + 1/48' --every half an hour
> > );
> > END;
> > /
> >
> > AFAIK it complies with the examples in the online doc CD. I compared Tom
> > Kytes book as well ... I have no clue.
> >
> > Any comments are appreciated. ThanX !
> > Oracle EE 8.1.7, SQL*Plus
> >
> > Jan
> >
> >
>
>
Received on Tue Nov 26 2002 - 07:35:59 CST