Optimistic locking with ora_rowscn

From: Tony Sequeira <tony_at_sequeira.org.uk>
Date: Wed, 17 Feb 2010 09:43:09 +0000
Message-ID: <4B7BBA2D.40004_at_sequeira.org.uk>


I'm involved with the development of a web based application, which will update tables in an 11gR2 database.

The proposal is to use a timestamp column which will be checked prior to an update.

I believe that using ora_rowscn is a "better" way to do this.

I would like to recommend that we use it instead.

Anyone use it? Any gotchas?

S. Anthony Sequeira

I hope you're not pretending to be evil while secretly being good. That would be dishonest.
-- http://www.freelists.org/webpage/oracle-l
Received on Wed Feb 17 2010 - 03:43:09 CST

Original text of this message