Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: trapping errors
Jan-Peter Meyer wrote:
>
> Carlo Di Mascio wrote:
> >
> > Hi Folks
> >
> > If I have a batch job that is calling some stored procedures. If the
> > stored procedure fails how does someone trap the errors. I'm looking to
>
> If you are executing the procedure from SQL*Plus you can use
> whenever sqlerror .... to detect and act on errors (Rollback,...)
>
> > add the batch job to an operation monitoring tool?
> >
> > I would appreciate any answers, thanks
> >
> > -oOO--(oo)-------------------------------------------------------------
I would prefer to get the errcode & errmesg as OUT from the procedure & then just after the call check if errcode <> 0. This is the best way i could think of.
Avinash Received on Mon Dec 29 1997 - 00:00:00 CST