Transaction & Locks Problem

Question

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.

Answer 1

Other sessions can do a "dirty read" of the record using NO-LOCK. But they will not be able to lock it or update it until the transaction is committed (or rolled back). And that won't happen until the repeat block iterates or you leave it.