Re: Trapping Errors in SQL*Plus

Even in SQL*Plus you can use the statement whenever sqlerror exit [commit|rollback];

This makes the script exit SQL*Plus when an error occurs.

--
Have a nice day
Michel

Mark Sims <mark.k.sims_at_bt.com> a écrit dans le message : 3826C2A7.FB024785_at_bt.com...
> Hello,
>
> Has anyone come across a technique for trapping errors after an SQL
> statement in SQL*Plus?
>
> We have some code that performs a number of large queries in sequence.
> For various reasons it is neither practical to wrap them in PL/SQL nor
> to use embedded SQL. At present, if an error occurs, the process
> continues to the end and the problem is detected manually by checking a
> log file. We want to terminate the process as soon as possible and
> record the reason for the problem.
>
> Thanks in advance,
>
> Mark Sims
>
Received on Mon Nov 08 1999 - 06:46:56 CST