Re: Optimistic locking with ora_rowscn

From: Connor McDonald <>
Date: Wed, 17 Feb 2010 22:40:12 +0800
Message-ID: <>

There is a possible issue with ora_rowscn, which Oracle document at
"expected behaviour"....

You would expect that you could just do:

select rowscn, <cols>

and then issue

set cols = ...
where <criteria>
and rowscn = :queried_rowscn

but you can't. Search Metalink for bug 5270479 - you need additional
"select for update" commands...

Connor McDonald

"Semper in excremento, sole profundum qui variat"
Received on Wed Feb 17 2010 - 08:40:12 CST

Original text of this message