Thread: FOR UPDATE NOWAIT
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. -- Pete Lovell ____________________________________________________________ Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie