NOWAIT for row-level lock?

Is there a way to NOT wait for a row -level lock held by another transaction?

For instance, if:

txn1 selects row 1 for update at a point in time. At a later time, txn2 selects the same row for update, but txn1 still holds the lock (txn1 hasn't commited).

Instead of waiting, is there a way to let txn2 know that the record is locked, so they can move on to another record?

Thanks,

Jerry

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Oct 23 1998 - 09:34:16 CDT