Re: PL/SQL calling Procedures from others

Maybe the Oracle DBMS_JOB.SUBMIT requires a function instead of a procedure? If so, redefine the the procedure to be a function. Just guessing.

-Dan

Thomas Ruschival <t.ruschival_at_vivid-md.de> wrote in message news:9n2j6q$54kt7$1_at_ID-37256.news.dfncis.de...
> 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 - 10:01:08 CDT