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

On-Lock Trigger

Description

Fires whenever Oracle Forms would normally attempt to lock a row, such as when an operator presses a key to modify data in an item. The trigger fires between the keypress and the display of the modified data.

Definition Level form or block

Legal Commands

SELECT statements, unrestricted Built-ins

Enter Query Mode no

Usage Notes

Caution

In special circumstances, you may use the LOCK TABLE DML statement in an On-Lock trigger. However, as this could result in other users being locked out of the table, please exercise caution and refer to the ORACLE RDMS Database Administrator's Guide before using LOCK TABLE.

On Failure

When the On-Lock trigger fails, the target record is not locked and Oracle Forms attempts to put the input focus on the current item. If the current item cannot be entered for some reason, Oracle Forms attempts to put the input focus on the previous navigable item.

Fires In

Lock the Row


LOCK_RECORD Built-in