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

When-Clear-Block Trigger

Description

Fires just before Oracle Forms clears the data from the current block.

Note that the When-Clear-Block trigger does not fire when Oracle Forms clears the current block during the CLEAR_FORM event.

Definition Level form or block

Legal Commands

SELECT statements, unrestricted Built-ins

Enter Query Mode yes

Usage Notes

Use a When-Clear-Block trigger to perform an action every time Oracle Forms flushes the current block. For example, you might want to perform an automatic commit whenever this condition occurs.

In a When-Clear-Block trigger, the value of SYSTEM.RECORD_STATUS is unreliable because there is no current record. An alternative is to use GET_RECORD_PROPERTY to obtain the record status. Because GET_RECORD_PROPERTY requires reference to a specific record, its value is always accurate.

On Failure

no effect on the clearing of the block

Fires In

CLEAR_BLOCK

COUNT_QUERY

ENTER_QUERY

Open the Query


CLEAR_FORM Built-in

GET_RECORD_PROPERTY Built-in