Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Exception - Exit a Stored Program
RAISE_APPLICATION_ERROR() might do that.
NeedaHoliday wrote:
> I know about the rollback. My exception handler calls a sub-program
> that writes to an error table and sets a status flag. The weird thing
> is, I agree with you and thought that the program should end but not
> in this case, it continues to execute. There must be a way to kill
> the execution.
>
> On Thu, 21 Oct 1999 19:47:08 GMT, Peter Okhiria
> <peter.okhiria_at_mci.com> wrote:
>
> >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 - 15:26:34 CDT