Transaction & Locks Problem
- by jay
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.