A script-enabled browser is required for this page to function properly.

Locking Mode Property

Description

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

Refer to Built-in

GET_BLOCK_PROPERTY

SET_BLOCK_PROPERTY

Default

Automatic

Usage Notes

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