Helmut, It may not be supremely elegant but you can keep whenever sqlerror exit sql.sqlcode at the beginning, and put everything else into a begin -- do your stuff here exception when others then rollback; raise; end; block. HTH, S Faroult > Hi! > > I have a SQL*Plus script that rolls back whenever an error occurs: > > .... whenever sqlerror exit SQL.SQLCODE ROLLBACK > > Is there a way to get an exit code AND roll back when an error occurs? > > I know that "... whenever sqlerror exit 99" exits with an error code but it > does not roll back that transaction, i.e. if some insert statements were > already sucessful then they are not rolled back. > > Is there any way to exit with an error code and roll back the transaction? > > This is 9.2 on HP-UX. > > Thanks, > Helmut > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- -- Oracle scripts, papers and DBA Tools -- -- Oriole Corporation -- -- http://www.oriole.com/ -- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------