whenever sqlerror exit: exit code and rollback

From: Daiminger, Helmut <HELMUT.DAIMINGER_at_WWK.DE>
Date: Tue, 23 Mar 2004 11:20:10 +0100
Message-ID: <706FB6D452A69442B8275372F22C19150311068B@serv102.wwk.de>

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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Tue Mar 23 2004 - 04:17:49 CST