Re: PL/SQL calling Procedures from others

In article <9n2j6q$54kt7$1_at_ID-37256.news.dfncis.de>, Thomas Ruschival <t.ruschival_at_vivid-md.de> writes
>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);

You need to re-check your documentation regarding dbms_job for the correct syntax. From memory...

declare

        v_job number;
begin

        exec dbms_job.submit(v_job, 'fp_dba.monatsbericht;', SYSDATE, 'SYSDATE+1');
end;

Andy

-- 
Andy Hardy. PGP ID: 0xA62A4849
===============================================================