Re: Optimistic locking with ora_rowscn

From: Connor McDonald <mcdonald.connor_at_gmail.com>
Date: Wed, 17 Feb 2010 22:40:12 +0800
Message-ID: <5e3048621002170640k95f7a64w64ae79bcf3b3dadc_at_mail.gmail.com>

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_at_yahoo.com
web:   http://www.oracledba.co.uk



"Semper in excremento, sole profundum qui variat"


--
http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 17 2010 - 08:40:12 CST