Specifies when Oracle Forms tries to obtain database locks on rows that correspond to queried records in the form. The following table describes the allowed settings for the Locking Mode property:
Value |
Description |
---|---|
Automatic (default) |
Identical to Immediate if the datasource is an Oracle database. For other datasources, Oracle Forms determines the available locking facilities and behaves as much like Immediate as possible. |
Immediate |
Oracle Forms locks the corresponding row as soon as the end user presses a key to enter or edit the value in a text item. |
Delayed |
Oracle Forms locks the row only while it posts the transaction to the database, not while the end user is editing the record. Oracle Forms prevents the commit action from processing if values of the fields in the block have changed when the user causes a commit action. |
Applies to block
Set Oracle Forms, programmatically
Default
Automatic
For most applications use the default setting of Automatic.
The Immediate setting remains for compatibility with existing applications, but there is no reason to use it in new applications. Use Automatic instead.
The Delayed setting is useful for applications that must minimize the number of locks or the amount of time that rows remain locked. Use delayed locking if the form's Isolation Mode property has the value Serializable.
The main drawbacks of delayed locking are