Oracle row locking

I'm using Oracle 8.0.8.2 on NT 4.0.

In my application, I use a query to obtain a row lock. 'Select key_id from f_standard where key_id=:key_id for update nowait'

This seems to work. User A gets a row lock. User B can see the lock.

My problem is that when User A goes to a different row, the lock remains on the previous row. I thought that a commit or rollback would release the lock. I've tried both.

What is the proper way to release a row lock?

--
Jim Poe
<jpoe_at_fulcrumit.com>
Fulcrum InteTech, Inc. Received on Fri Oct 09 1998 - 17:09:43 CDT