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
SELECT statements, PL/SQL, unrestricted Built-ins
Enter Query Mode no
no effect
Close The Query
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;