Subject | Re: [firebird-support] Transaction inside procedures. |
---|---|
Author | Nando Dessena |
Post date | 2005-01-04T18:47:08Z |
Waner,
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.
Ciao
--
Nando Dessena
http://www.flamerobin.org
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================
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.
Ciao
--
Nando Dessena
http://www.flamerobin.org
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================