Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with dbms_job package
Hi,
Is this edi_inv package name or schema name? Include the schema name in the call.
Are you able to run this function manually under the same user from which
you're trying to submit the job?
(check that the permissions are correct (not granted through a role, but
directly))
I assume that you have job_queue_processes set?
Check from alert.log for exact error message.
Tanel.
"Arturo" <aparafiniuk_at_rogers.com> wrote in message
news:U3d5a.25679$UXa.20481_at_news02.bloor.is.net.cable.rogers.com...
> 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 Sun Feb 23 2003 - 11:54:26 CST