Problem with dbms_job package
Date: Thu, 20 Feb 2003 13:16:30 GMT
Message-ID: <Oy45a.24364$Zr%.8434_at_news01.bloor.is.net.cable.rogers.com>
[Quoted] 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
Error explanation:
Cause: Some kind of error was caught in DBMS_IJOB.RUN. One or more jobs that were due to be run produced errors that they could not handle. Action: Look at the alert log for details on which jobs failed and why.
The alert log says:
- 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. Received on Thu Feb 20 2003 - 14:16:30 CET