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

On-Close Trigger

Description

Fires when an operator or the application causes a query to close. By default, Oracle Forms closes a query when all of the records identified by the query criteria have been fetched, or when the operator or the application aborts the query.

The On-Close trigger augments the normal Oracle Forms "close cursor" phase of a query.

Definition Level form, block

Legal Commands

SELECT statements, PL/SQL, unrestricted Built-ins

Enter Query Mode no

Usage Notes

On Failure

no effect

Fires In

ABORT_QUERY

Close The Query

On-Close Trigger Examples

The following example releases memory being used by a user-defined data access method via the transactional triggers.

BEGIN
IF NOT my_data source_open('DX110_DEPT') THEN
my_datasource_close('DX110_DEPT');
ELSIF form_fatal OR form_failure THEN
raise form_trigger_failure;
END IF;
END;


ABORT_QUERY Built-in