Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Exception - Exit a Stored Program
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 - 14:56:08 CDT