Subject Re: [firebird-support] Transactions within a stored procedure
Author unordained
If Firebird winds up supporting nested transactions for some reason (it didn't get that without my
noticing, did it?), will SP's then be able to at least start/stop their own internal transactions?
It would help make them a bit more fault-tolerant -- if something goes wrong, they could just undo
their local changes, possibly trying something else instead, without forcing the main transaction
calling the SP to do the work.

Just curious.

---------- Original Message -----------
> >Should it be possible to do a 'set transaction' within a stored
> >procedure in Firebird 1.5?
> In a word, no. A procedure is a black box which can not change the state
> of the calling transaction.
> Regards,
> Ann
------- End of Original Message -------