Subject | Re: [firebird-support] Re: logging exception message text in stored procedures |
---|---|
Author | Ann W. Harrison |
Post date | 2006-02-14T17:47:17Z |
tommyjky wrote:
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
>Ah! When we talk about exceptions, we mean special, user defined
>>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?
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