Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Exception - Exit a Stored Program
Tried this and I got the same results.
On Thu, 21 Oct 1999 20:26:34 GMT, George Wilson Mathias <george.mathias_at_mci.com> wrote:
>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:27:42 CDT