Optimistic locking with ora_rowscn

  • From: Tony Sequeira <tony@xxxxxxxxxxxxxxx>
  • To: Oracle List <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 17 Feb 2010 09:43:09 +0000


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.


Other related posts: