Re: Optimistic locking with ora_rowscn
Date: Wed, 17 Feb 2010 22:40:12 +0800
There is a possible issue with ora_rowscn, which Oracle document at
You would expect that you could just do:
select rowscn, <cols>
and then issue
set cols = ...
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.ukReceived on Wed Feb 17 2010 - 08:40:12 CST
"Semper in excremento, sole profundum qui variat"