Subject Re: [firebird-support] Re: logging exception message text in stored procedures
Author Ann W. Harrison
tommyjky wrote:

>
>>Ok, but how do I get the exception name? I know how to get SQLCODE
>
> and/or GDSCODE, but you are saying that I need the exception name so
> that I can query the RDB$EXCEPTIONS TABLE to get the RDB$MESSAGE,
> right?

Ah! When we talk about exceptions, we mean special, user defined
messages that are generated from stored procedures and triggers. If
you want all database errors, you've got two choices. One is that
there is a messages database called msg.fdb which is part of the
build, which has all the errors by code. The other is isc_interprete
a call that takes a status vector and returns a text message.


Regards,


Ann