Example optimisic offline lock in SQL/PL? Can someone show me an example of an optimistic offline lock in 
an Oracle Stored Procedure?
Typically I think that systems would select the ora_rowscn value when they read the data, and when they write it back they would specify that value as part of the update statement. If no rows are updated then either the record has been deleted or the record has changed.