Re: Problem with dbms_job package

Tried, didn't work.

Thanks anyways.

"Alexey Sergeyev" <a.sergeev_at_ibsp.ru> wrote in message news:b32ta4$kf8$1_at_slim.sovintel.ru...
>
> 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 - 16:57:56 CST