Trapping Errors in SQL*Plus

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:31:35 CST