Subject Re: [firebird-support] transaction in stored procedure
Author Alexandre Benson Smith
Em 13/4/2010 17:43, Alberti Tamas escreveu:
> Hi!
> I have a question about transactions. My plan is that a stored procedure
> logs its job in a database table, tought if the client rollback the
> transaction, the log inserts will be also rolled back. Is there any way
> how i can keep some inserts in a transaction? For example i start
> another transaction in the proc or do some inserts outside the
> transaction, what the client initiated?
> thanks
> Tamas Alberti

In the current fb versions you could use external tables that does
survive to a rollback.

In the upcomming FB 2.5 you will have autonomous transaction

see you !

Alexandre Benson Smith
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil