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
SELECT statements, unrestricted Built-ins
Enter Query Mode yes
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.
no effect on the clearing of the block
CLEAR_BLOCK
COUNT_QUERY
ENTER_QUERY
Open the Query