Subject Re: [firebird-support] Transaction inside procedures.
Author Nando Dessena

W> I wanna do "update" in a table inside of one procedure, and commit the
W> same update without commit the procedure's transaction.

W> Do the firebird has a resource to manipulate transactions inside
W> procedures?

No, you'd need support for nested transactions, which Firebird doesn't
have. AFAIK the closest you can get to what you want to achieve is
using savepoints (see docs), unless you rethink things at a broader
level to make your process a better fit for Firebird.

Nando Dessena
I support Firebird, I am a Firebird Foundation member!
Join today at