Re: Optimistic locking with ora_rowscn

From: Tony Sequeira <tony_at_sequeira.org.uk>
Date: Wed, 17 Feb 2010 09:55:33 +0000
Message-ID: <4B7BBD15.7080701_at_sequeira.org.uk>

Brooks, Dominic (London)(c) wrote:
> 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.
>

Yes, I know about rowdependencies, thanks.

Ah, thanks, didn't know about VPD. Don't think it will be used, but I'll have to check.

> Cheers,
> Dominic
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] 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.
> ++
>
>
> --
> http://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
> **********************************************************************
>
>
>

-- 
S. Anthony Sequeira
++
Armanism:
	After Giorgio Armani; an obsession with mimicking the seamless
and (more importantly) *controlled* ethos of Italian couture.  Like
Japanese Minimalism, Armanism reflects a profound inner need for
control.
		-- Douglas Coupland, "Generation X: Tales for an Accelerated
		   Culture"
++


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

Received on Wed Feb 17 2010 - 03:55:33 CST