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.
>

Look in the table rdb$exceptions - rdb$message may be what you want.
I'd suggest using an external table (aka flat file) for logging. As
a general thing you want to log errors even if they resulted in the
transaction rolling back. External tables don't roll back.

Regards,


Ann