EXCEPTION SYNTAX
From: Joet Singh <jsingh_at_bigfoot.com>
Date: Sat, 6 Nov 1999 04:16:32 -0600
Message-ID: <M6UU3.13341$Ph7.93688_at_insync>
Hi All,
[Quoted] 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 [Quoted] procedure B. This variable should be number datatype but when somebody [Quoted] tries to pass "letters" in the variable, I want to raise an exception. I [Quoted] have tried following:
Date: Sat, 6 Nov 1999 04:16:32 -0600
Message-ID: <M6UU3.13341$Ph7.93688_at_insync>
Hi All,
[Quoted] 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 [Quoted] procedure B. This variable should be number datatype but when somebody [Quoted] tries to pass "letters" in the variable, I want to raise an exception. I [Quoted] 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?
Received on Sat Nov 06 1999 - 11:16:32 CET