RE: Optimistic locking with ora_rowscn

From: Brooks, Dominic (London)(c) <"Brooks,>
Date: Wed, 17 Feb 2010 09:47:15 -0000
Message-ID: <>

You need to enable row dependencies so that ora_rowscn is not just at the block level.

Also, ora_rowscn does not work with VPD.


-----Original Message-----

[] On Behalf Of Tony Sequeira Sent: 17 February 2010 09:43
To: Oracle List
Subject: Optimistic locking with ora_rowscn


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.


 Please consider the environment before printing this email or its attachments. The contents of this email are for the named addressees only. It contains information which may be confidential and privileged. If you are not the intended recipient, please notify the sender immediately, destroy this email and any attachments and do not otherwise disclose or use them. Email transmission is not a secure method of communication and Man Investments cannot accept responsibility for the completeness or accuracy of this email or any attachments. Whilst Man Investments makes every effort to keep its network free from viruses, it does not accept responsibility for any computer virus which might be transferred by way of this email or any attachments. This email does not constitute a request, offer, recommendation or solicitation of any kind to buy, subscribe, sell or redeem any investment instruments or to perform other such transactions of any kind. Man Investments reserves the right to monitor, record and retain all electronic communications through its network t  o ensure the integrity of its systems, for record keeping and regulatory purposes. Visit us at:

-- Received on Wed Feb 17 2010 - 03:47:15 CST

Original text of this message