> Hi,
> Is it possible to get the exception message in a stored procedure
> containing "when any do <some stuf>" ?
> It would be usefull to get the engine error message to identify the
> source of the exception.

With Firebird >= 1.5, you can access the exception error code via the
SQLCODE context variable in a WHEN ANY block.



--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com