Subject Re: [firebird-support] Autonomous transactions or smth. like this?
Author Helen Borrie
At 12:26 PM 2/08/2005 +0000, you wrote:
>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?

All unnecessary. Just insert your log records to an external
table. External tables are not subject to commit and rollback, i.e. their
data survives rollback.

The beauty is that you can read your external table at any time. Deletes
don't incur garbage.