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


Other related posts: