At 01:44 PM 12-02-02 +1300, you wrote:

>What is the sqlcode when a user defined exception is raised inside
>a stored proc?

Use the syntax
WHEN EXCEPTION exception_name DO...

cheers,
Helen


All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org
_______________________________________________________