Re: Problem with dbms_job package

[Quoted] In message <Oy45a.24364$Zr%.8434_at_news01.bloor.is.net.cable.rogers.com>, Arturo <aparafiniuk_at_rogers.com> writes
>Hi All,
>
>I'm having a bit of a problem running a procedure using dbms_jobs. I can
>execute the procedure from the command line in SQL*Plus. I can't using
>dbms_job package. Here is what I'm doing:
>
>declare a number;
>begin
>dbms_job.submit(a, 'declare a number; begin
>a:=edi_inv.edi_pre_post_process(0, 5372, 10400); end;');
>dbms_job.run(a);
>end;
>/
>
>ORA-12011 execution of num jobs failed
>
>*** SESSION ID:(11.2961) 2003.02.19.09.14.24.000
>*** 2003.02.19.09.14.24.000
>ORA-12012: error on auto execute of job 854
>ORA-06550: line 1, column 96:
>PLS-00201: identifier 'UCS.EDI_INV' must be declared
>ORA-06550: line 1, column 96:
>PL/SQL: Statement ignored
>
>It's all on Oracle7 Server Release 7.3.4.0.1. PL/SQL Release 2.3.4.0.0.
>
>Thank you for any hints,
>
>a.
>
>

The error message would tend to imply that there is no edi_inv package in the UCS schema or maybe its not valid.

To ensure its not a dbms_job issue, execute what you have inside the quotes in SQL*Plus.

Cheers

-- 
Mike Cox