On Mon, 17 Mar 2014 18:54:21 +0400, Dmitry Kuzmenko <kdv@...> 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