On 5/8/11 6:50 AM, Mark Rotteveel wrote:

> On 8-5-2011 9:32, Doug Chamberlin wrote:
>> The Firebird transaction model does not allow for transaction management
>> (commit,rollback, etc) within a stored procedure. Only the calling
>> application manages transactions.
> Since 2.5 Firebird has autonomous transactions (see
> http://www.firebirdsql.org/rlsnotesh/rlsnotes25.html#rnfb25-psql-auton )
> this might (or might not) be an answer for Olafs needs
>
> Mark

Yeah, it might help him out. But the model for transaction management in
Firebird remains the same. So in the long run I think he would be better
off not fighting against Firebird's design even though new stuff has
been added to make that fight easier.