Re: Trapping Errors in SQL*Plus

Michel Cadot schrieb:

> 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
>

Make use of

whenever sqlerror exit [failure|success] [commit|rollback]

do not rely on default behavior ... :o)

Regards, Stephan
--

Dipl.-Inf. (FH) Stephan Born   | beusen Consulting GmbH
fon: +49 30 549932-0           | Landsberger Allee 392
fax: +49 30 549932-29          | 12681 Berlin
mailto:stephan.born_at_beusen.de  | Germany
---------------------------------------------------------------
       PGP-Key verfügbar       |      PGP-Key available
---------------------------------------------------------------