Oracle Apex - Automatic Row Processing (DML)


Data Manipulation process: where:

  • No SQL coding is required
  • Lost update detection is implemented

(Checksum|Optimistic locking|Lost update ?)

Lost update detection ensures data integrity in applications where data can be accessed concurrently.

Wizard generated tabular forms built-in DML, include a checksum column to prevent lost updates. Using a method called optimistic locking, a checksum is computed for each row when rendering a tabular form. This checksum is stored in an extra hidden tabular form column.

Upon submission of the form for update, an additional set of checksums is computed on the then current data stored in the database. The new checksums are compared to those built when the tabular form was first rendered, and if there are any mismatches, the update is rejected, because the data in the database was either modified by another user or anther process in the time between the tabular form was rendered and the time the data was submitted.

Powered by ComboStrap