Help with "select .... for update ... nowait" message
Hi,
How can I get the Oracle 10 g2 server return code issued when a cursor attemps to select ... for update nowait
and modify the control in the pl/sql block accordingly if one row is already involved in a transaction?
Many thanks
Edited by: JeanParis on Feb 9, 2009 2:57 AM
Hi again
i have done a search and I found ( dated 2004 ):
it will raise an exception 54. you have to catch it.
So that means I have to manage the cursor inside an inner block et loop until the lock is released?
Edited by: JeanParis on Feb 9, 2009 3:02 AM
Edited by: JeanParis on Feb 9, 2009 3:03 AM