how to call a stored procedure from an oracle job ?

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 ! Received on Wed Sep 08 2004 - 11:07:03 CDT