Hi!

In my Firebird application I need to write information about all
errors that occur in some stored procedure to a special table.

The problem is that if error occurs rollback is done (at least to
savepoint). So, I need to write error information in a special
transaction. How can I do that? In Oracle, there is autonomous
transactions or daemons & pipes. In PostgreSQL there is special user
function that executes some SQL in a new connection to database. How
can it be done in Firebird? Maybe somebody already written an
UDF that does this thing?

Thanks in advance.

Regards,
Dmitry