PL/SQL calling procedures from others

[Thomas Ruschival]

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

[Yannick Kermabon]

"Thomas Ruschival" <t.rus...@vivid-md.de> wrote in
news:9n2ji5$52hs5$1...@ID-37256.news.dfncis.de:

Hi

Command and interval fields are VARCHAR2 type :

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

Hth
YK

[Lothar Armbruester]

Thomas Ruschival wrote:
> 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);
>

[...]

Hello Thomas,
I think you have to give the name of your procedure to submit:

EXEC DBMS_JOB.SUBMIT(1, 'FP_DBA.MONATSBERICHT', SYSDATE, SYSDATE+1);

The second parameter is of varchar2 type.
I also think, the fourth parameter has to be something different (maybe
also included in quotes) but I don't have experience with dbms_job,
so this is a wild guess. :-)

Hope that helps,
Lothar

--
Lothar Armbrüster | l...@oktagramm.de
Hauptstr. 26 | l...@heptagramm.de
D-65346 Eltville | lothar.ar...@t-online.de