Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

select for update wait: can you specify a timeout?

13030Jul 23 2007 — edited Jul 23 2007
I have a SELECT ... FOR UPDATE WAIT. I would like to specify a timeout value in case a deadlock is detected (highly unlikely if not impossible but want to future-proof it from idiot programmers) Doesn't look like this is possible in 9i, is it?

What would the best workaround be -- have a loop that does a SELECT FOR UPDATE NOWAIT, catches the exception, and then sleeps until the timeout expires (checking again periodically)?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 20 2007
Added on Jul 23 2007
2 comments
7,254 views