Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Exception - Exit a Stored Program

Re: Exception - Exit a Stored Program

From: Peter Okhiria <peter.okhiria_at_mci.com>
Date: Thu, 21 Oct 1999 19:47:08 GMT
Message-ID: <380F1AC2.71947362@mci.com>


To avoid data corruption, do a rollback in the exception body. If I'm not mistaking, an exception will also terminate the execution of the procedure

NeedaHoliday wrote:

> Could someone please tell me if there is a way to abort an executing
> procedure when an exception is encountered. Severe data coruption is
> occurring because the procedure continues to execute.
>
> Thanks in advance.
>
> james.stewart_at_nospamPWGSC.GC.CA
>
> Please remove nospam to email
Received on Thu Oct 21 1999 - 14:47:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US