When attempting to lock a row in a table in Oracle
using SELECT...FOR UPDATE it is possible to append
NOWAIT to the query to ensure that the query is
cancelled if the row is already locked.
I could really do with a feature like this, and so:
- Does either this feature exist?
- If not, is it possible to determine if a row is
locked before using SELECT...FOR UPDATE?
- If not is it possible to set a 'waiting' time for
queries that are waiting for a row lock to expire?
- Is there a transacation time out?
Thanks.
---------
ling