Re: how to call a stored procedure from an oracle job ?

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 8 Sep 2004 18:23:09 +0200
Message-ID: <413f315e$0$7595$636a15ce@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;

-- 
Regards
Michel Cadot

Received on Wed Sep 08 2004 - 11:23:09 CDT