Transaction & Locks Problem
Posted
by jay
on Stack Overflow
See other posts from Stack Overflow
or by jay
Published on 2010-06-11T11:48:40Z
Indexed on
2010/06/11
11:53 UTC
Read the original article
Hit count: 280
with in do transaction, i defined a label and in this label i am accessing a table with exclusive-lock.and at the end of label i have done all the changes in that table. bt now i am with in transaction block. Now, i tried to access that same table in another session.then it show an error, Table used by another user. So is it possible that, can we release teh table with in transaction,so another user can access it. Exe Session1)
DO TRANSACTION:
loopb:
repeat:
-- ---------------------> control is here right now. end. /repeat/
--
end /do transaction/ Session2)
I tried to access same table,bt it show an error,that table locked by another user.
© Stack Overflow or respective owner
