lock timeout

From: <timkarnold_at_comcast.net>
Date: Sun, 01 Sep 2002 03:00:20 GMT
Message-ID: <8pfc9.325656$m91.13279141@bin5.nnrp.aus1.giganews.com>

Colleagues,

Consider the situation where a user tries to update a record: Select * from tabA where PK = 'value' for update nowait The record selected is now locked until a commit, rollback or the session is closed.
Is there any way to timeout the lock? After, say 45 minutes or an hour?

Has anyone used DBMS_LOCK to do the equivalent?

TIA,
Tim Received on Sat Aug 31 2002 - 22:00:20 CDT