Re: Exception - Exit a Stored Program

From: Ole Christian Meldahl <konocm_at_statoil.com>
Date: Mon, 25 Oct 1999 08:52:09 +0200
Message-ID: <3813FE19.8312B5D4@statoil.com>

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 - 01:52:09 CDT