Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Problem with dbms_job package

Problem with dbms_job package

From: Arturo <aparafiniuk_at_rogers.com>
Date: Thu, 20 Feb 2003 13:16:50 GMT
Message-ID: <6z45a.24367$Zr%.4198@news01.bloor.is.net.cable.rogers.com>


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:

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 - 07:16:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US