RE: Optimistic locking with ora_rowscn
- From: "Brooks, Dominic (London)(c)" <dbrooks@xxxxxxxxxxxxxxxxxx>
- To: <tony@xxxxxxxxxxxxxxx>, "Oracle List" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 17 Feb 2010 09:47:15 -0000
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.
Cheers,
Dominic
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Tony Sequeira
Sent: 17 February 2010 09:43
To: Oracle List
Subject: Optimistic locking with ora_rowscn
Hi,
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.
++
--
//www.freelists.org/webpage/oracle-l
**********************************************************************
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 to ensure
the integrity of its systems, for record keeping and regulatory purposes.
Visit us at: www.maninvestments.com
TG0908
**********************************************************************
--
//www.freelists.org/webpage/oracle-l
Other related posts:
