whenever sqlerror exit: exit code and rollback
- From: "Daiminger, Helmut" <HELMUT.DAIMINGER@xxxxxx>
- To: "'LazyDBA.com Discussion'" <oracledba@xxxxxxxxxxx>,"'ORACLE-L (oracle-l@xxxxxxxxxxxxx)'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 23 Mar 2004 11:20:10 +0100
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
-----------------------------------------------------------------
Other related posts:
