On Mon, 17 Mar 2014 18:54:21 +0400, Dmitry Kuzmenko <[email protected]> wrote: > dyc> 2) Would it be better to a START TRANSACTION / COMMIT inside the > dyc> procedure as opposed to putting the transaction control in the > FbClient? > > you can't do it, at all.
No, but you can of course use IN AUTONOMOUS TRANSACTION within the stored procedure. See http://www.firebirdsql.org/file/documentation/reference_manuals/reference_material/html/langrefupd25-psql-autonomous-trans.html Although that might still result in "deadlocks". Mark
