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!

FOR UPDATE NOWAIT issue

brainstormerMay 6 2013 — edited May 9 2013
Oracle Version: 10.2.0.5
O/S : Redhat


Hi,

I have a select statement that is wrapped in the FOR UPDATE NOWAIT clause. This is embedded in a stored procedure and this stored procedure may be called concurrently by multiple threads from a .net application.

Off late i have noticed that the proc has been returning the same value to 2 different calls - this defeats the purpose of row-level locking that FOR UPDATE NOWAIT does. I did notice that the procedure calls from the .net application where 100th of a millisecond apart.

Is there any workaround to avoid the same row being returned to different calls? or is this a known behaviour and i just have to live with it?

Edited by: brainstormer on May 6, 2013 12:56 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 6 2013
Added on May 6 2013
8 comments
4,435 views