Re: Exception - Exit a Stored Program

I have read and tried this. I made sure the the error was not trapped in the calling program. When an exception was raised, the calling program did not abort but kept on executing. THe only way I could get the calling program to halt is to verify an exception indicator that was set in the called program. At that point I raise an exception in the calling program.

I appreciate your help. Maybe I am missing something.

On Mon, 25 Oct 1999 08:52:09 +0200, Ole Christian Meldahl <konocm_at_statoil.com> wrote:

>NeedaHoliday wrote:
>
>> UPDATE -
>>
>> RAISE_APPLICATION_ERROR works fine. THe problem is the calling
>> program doesn't know that the called program has encountered an error.
>>
>> Is there a quick way to identify to the calling program that an
>> exception has occurred. I was going to use a parameter exception
>> indicator to do this. Any better alternatives.
>
>You should read up on exceptions and propagation in the
>PL/SQL-manual(technet.oracle.com)
>
>Hint: An exception raised by RAISE_APPLICATION_ERROR will propagate to the
>calling procedure, make sure it's not trapped!!!
>
>ole c
>
>
Received on Mon Oct 25 1999 - 08:20:21 CDT