Re: Optimistic locking with ora_rowscn
- From: Connor McDonald <mcdonald.connor@xxxxxxxxx>
- To: Oracle List <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 17 Feb 2010 22:40:12 +0800
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
update
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
===========================
email: connor_mcdonald@xxxxxxxxx
web: http://www.oracledba.co.uk
"Semper in excremento, sole profundum qui variat"
Other related posts:
