Re: whenever sqlerror exit: exit code and rollback
- From: <sfaroult@xxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 23 Mar 2004 05:33:34 EST5EDT
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
-----------------------------------------------------------------
Other related posts:
