>> How can I fetch the message text of an exception in an when-block?
>
> No way. Give up.
>
> SY, SD.

It depends :-)

If this is a custom exception, and you're only catching that particular
exception, you could query RDB$EXCEPTIONS for the text.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com