Optimistic locking with ora_rowscn
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 SequeiraReceived on Wed Feb 17 2010 - 03:43:09 CST
I hope you're not pretending to be evil while secretly being good. That would be dishonest.