Thanx, that's exactly what I was looking for :-)

> 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
> _______________________________________________________
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>

Regards

Sandeep

Software Developer
CFL
sandeep@...
http://www.cfl.co.nz