Subject | Re[4]: [firebird-support] Deadlock |
---|---|
Author | Dmitry Kuzmenko |
Post date | 2014-03-17T16:52:52Z |
Hello, Mark!
Monday, March 17, 2014, 7:30:16 PM, you wrote:
MR> procedure. See
Mark! :-) By the question it is clear that author have very sketchy
knowledge about transactions (if any). So, I decided not to speak
about autonomous transactions at all, because it can lead to
"misused feature" situation.
(at least because autonomous have same paramaters that have
parent transaction, so, wait here can double problems).
p.s. Sorry, Dixon.
--
Dmitry Kuzmenko, www.ib-aid.com
Monday, March 17, 2014, 7:30:16 PM, you wrote:
>> you can't do it, at all.MR> No, but you can of course use IN AUTONOMOUS TRANSACTION within the stored
MR> procedure. See
Mark! :-) By the question it is clear that author have very sketchy
knowledge about transactions (if any). So, I decided not to speak
about autonomous transactions at all, because it can lead to
"misused feature" situation.
(at least because autonomous have same paramaters that have
parent transaction, so, wait here can double problems).
p.s. Sorry, Dixon.
--
Dmitry Kuzmenko, www.ib-aid.com