"Michel Cadot" <micadot{at}altern{dot}org> wrote in message news:<413f315e$0$7595$636a15ce_at_news.free.fr>...
> "freak" <blx999_at_gmx.de> a écrit dans le message de
> news:d0913092.0409080807.3f8f049_at_posting.google.com...
> > HI
> >
> > What i am trying to do is to call a stored procedure 'proc' defined
> > for user 'user1' from an oracle job every midnight at 12.
> >
> > the sql snipp
> >
> > BEGIN
> > DBMS_JOB.SUBMIT
> > (job => 1
> > ,what => user1.proc
> > ,next_date => 'TRUNC(SYSDATE + 1)'
> > ,interval => 'TRUNC(SYSDATE + 1)'
> > );
> > END;
> >
> > only says:
> > ,what => user1.proc
> >
> > FEHLER in Zeile 4:
> > ORA-06550: Zeile 4, Spalte 21:
> > PLS-00222: In diesem Geltungsbereich ist keine Funktion mit dem Namen
> > 'proc' vorhanden
> > ORA-06550: Zeile 2, Spalte 1:
> > PL/SQL: Statement ignored
> >
> > could anyone let me know how i can call a simple stored procedure from
> > a job, please ?
> >
> > thanx in advance !
>
> Type of "what" is varchar2 => add '
> Type of "next_date" is date => remove '
>
> BEGIN
> DBMS_JOB.SUBMIT
> (job => 1
> ,what => 'user1.proc;'
> ,next_date => TRUNC(SYSDATE + 1)
> ,interval => 'TRUNC(SYSDATE + 1)'
> );
> END;
works very well,
thanks a lot !
Received on Thu Sep 09 2004 - 04:34:08 CDT
