Re: Trapping Errors in SQL*Plus

Many thanks for the suggestion. Whilst this works in the sense of stopping the process it doesn't allow us to trap the reason for the failure (and hence stop gracefully).

Regards,

Mark Sims

Michel Cadot wrote:

> 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.
>
>
>
Received on Mon Nov 08 1999 - 08:00:50 CST