Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with dbms_job package
Arturo wrote:
> 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
Before run a new job, try to execute commit:
declare a number;
begin
dbms_job.submit(a, 'declare a number; begin
a:=edi_inv.edi_pre_post_process(0, 5372, 10400); end;');
COMMIT;
dbms_job.run(a);
end;
Alexey Sergeyev. Received on Thu Feb 20 2003 - 08:47:54 CST