Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL calling procedures from others

Re: PL/SQL calling procedures from others

From: Yannick Kermabon <y.kermabon_at_tegelog.fr>
Date: 04 Sep 2001 16:23:41 GMT
Message-ID: <3b95000d$0$14583$4d4eb98e@read.news.fr.uu.net>


"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US