At 09:52 AM 14/02/2006, tommyjky wrote:

>I have a store procedure in which I want to to write exeptions to a
>log table. When I get an error, I want to call a stored procedure and
>send the text of the error message and write it to a table. I don't
>know the field that the error text is stored in. Can someone please
>tell me the name of the field where I can get the error message text.

The short answer is that there isn't a "field". Exceptions exist on
the server as numbers. When they are returned to a client, you get
those numbers, along with the associated text for each number, in an
array that is populated at the interface, i.e. after the exception
has left the server, from firebird.msg.

The long answer is that, if you want to have text available on the
server to explain each exception, you'll need to create custom
exceptions for each one you might ever want to log. You can query
the system table RDB$EXCEPTIONS then by passing the identifier of
your custom exception as a string and getting back the text you
defined for that exception; or, in Fb 1.5 and higher, you can
override the defined text and store that in your log instead.

Something you'll have to watch is, if you are writing your log
records to an ordinary table, rather than an external table, the log
records will disappear along with everything else if the transaction
gets rolled back. (Log records written to an external table will survive.)

./heLen