Re: EXCEPTION SYNTAX

Joet,

Try placing the exception handler code in the trigger that calls procedure (A).

In article <M6UU3.13341$Ph7.93688_at_insync>,   "Joet Singh" <jsingh_at_bigfoot.com> wrote:
> Hi All,
> I am trying to raise an exception and not having very much luck. The
> problem is as follow: I have a variable that is passed from
procedure A to
> procedure B. This variable should be number datatype but when
somebody
> tries to pass "letters" in the variable, I want to raise an
exception. I
> have tried following:
>
> In Procedure B exception section I have following lines.
> EXCEPTION
> when value_error then
> "do something"
> when others then
> "do something"
> END;
>
> Neither of these exceptions are raised. Any ideas what is going on?
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Nov 06 1999 - 14:26:28 CET