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.


Other related posts: