Subject Re: [firebird-support] transaction in stored procedure
Author Alberti Tamas
Thanks

Sorry i forget to say i have fb 2.0
is there anyi option ffor this in 2.0?

t

Zaher Dirkey wrote:
>
>
> On Tue, Apr 13, 2010 at 10:43 PM, Alberti Tamas <tom@...
> <mailto:tom%40ambush.hu>> wrote:
>
> >
> >
> > 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?
> >
> >
> Check Autonomous Transactions
> http://www.ibsurgeon.com/articles/item122
> <http://www.ibsurgeon.com/articles/item122>