Re: Problem with dbms_job package

That's my point, it works as a stanalone PL/SQL block, it doesn't when submitted as a job. Other procedures work using the dbms_job package. Same user, etc...

"Mike" <mike_at_nospam.demon.co.uk> wrote in message news:SwAFV5D$ESV+EwJi_at_ntlworld.com...
> 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
Received on Thu Feb 20 2003 - 23:59:10 CET