| Subject | Re: [firebird-support] Transactions within a stored procedure |
|---|---|
| Author | unordained |
| Post date | 2004-03-02T01:04:02Z |
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.
-Philip
---------- Original Message -----------
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.
-Philip
---------- Original Message -----------
> >Should it be possible to do a 'set transaction' within a stored------- End of Original Message -------
> >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