Re: trapping errors

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)-------------------------------------------------------------
> (_) carlod_at_visioneeringpartners.com
> ------------OOo--------------------------------------------------------
 

-- 
---------------------------------------------------------------------
Jan-Peter Meyer                            jan-peter.meyer_at_mch.sbs.de
Siemens Business Services                  IS E 1
---------------------------------------------------------------------
--