Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL calling procedures from others
"Thomas Ruschival" <t.ruschival_at_vivid-md.de> wrote in
news:9n2ji5$52hs5$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
>
>
>
>
>
Hi
Command and interval fields are VARCHAR2 type :
SQL> EXEC DBMS_JOB.SUBMIT(1, 'fp_dba.monatsbericht;', SYSDATE,
'SYSDATE+1');
Hth
YK
Received on Tue Sep 04 2001 - 11:23:41 CDT
![]() |
![]() |