PL/SQL calling Procedures from others

Hi ,

I wrote a procedure named "monatsbericht" it is in belongs to fp_dba. I am logged in as fp_dba on
ORACLE 8.0.5 via SQL*PLUS and I can call this Procedure. I behaves just as it should.
Now I want to create a job that runs daily using this Procedure. This Is my code, according to the Admistrators Guide and PL/SQL Packet Reference :

SQL> EXEC DBMS_JOB.SUBMIT(1, fp_dba.monatsbericht, SYSDATE, SYSDATE+1);

It doesnīt submit this Job, it throws an PLS-0222 error:

PLS-00222 no function with name 'string' exists in this scope Cause: An identifier being referenced as a function was not declared or actually
represents another object (for example, it might have been declared as a procedure).

How can I add this procedure to he scope? I am a newbie so donīt wonder about my questions.

Thanks Thomas Received on Tue Sep 04 2001 - 08:03:52 CDT