I too need this information. While I can see the SQLCODE -625, I would
like to log the actual message to my external table log so I know what
column and what value caused the failure.

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of
kimon_the_athenian2
Sent: Friday, April 29, 2005 9:37 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] How to get last error message in procedure

Hi

I want to catch any exception in a stored procedure, then concatenate
the error message with additional info and then raise exception with
more info. How to get error message of last exception?

Aivar






Yahoo! Groups Links