Re: Q: "Autorollback" after raise_application_error()

A copy of this was sent to Gombos Bertalan <bgombos_at_freemail.c3.hu> (if that email address didn't require changing) On Thu, 28 Oct 1999 16:48:37 +0200, you wrote:

>Hi all,
>
> When I call a stored procedure from OCI, Oracle generates a savepoint to
>begin of the procedure. If I issue a raise_application_error() and this
>error reaches the caller environment (Power Builder), Oracle gives a
>rollback to the former savepoint.
> Is it possible to prevent Oracle from rollbacking?
>
>Bye:

catch the exception in the stored procedure and handle it there. If the exception is allowed to propagate to the top level -- the work is (correctly) rolled back. If you catch and handle the exception (eg: Ignoring it is one way of 'handleing' it), then the client will not rollback to savepoint since the procedure was 'successful'.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Oct 28 1999 - 10:08:57 CDT