select ...for update wait

You can do select .... for update wait, Specify WAIT to instruct the database to wait integer seconds for the row to become available and then return control to you. i am using oracle 10g with patch set 1 , but looks like this doesn't work, one session has the row lock, the other session wait forever. For our application, we need to be able to wait for 60 sec to get the error message return if the row locked still unavailable. thanks for help Received on Wed Dec 15 2004 - 11:04:05 CST