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.


++



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