Fires when Oracle Forms would normally execute the open cursor, parse, and execute phases of a query, to identify the records in the database that match the current query criteria.
Definition Level form or block
SELECT statements, PL/SQL, unrestricted Built-ins
Enter Query Mode no
Use an On-Select trigger to open and execute the database cursor. Specifically, use this trigger when you are retrieving data from a non-ORACLE data source. The On-Select trigger can be used in conjunction with the On-Fetch trigger to replace the processing that normally occurs in the EXECUTE_QUERY Built-in subprogram.
To perform the default Oracle Forms processing from this trigger, include a call to the SELECT_RECORDS Built-in.
no effect
Open The Query
IF Get_Application_Property(DATASOURCE) = 'DB2' THEN
User_Exit ( 'Query' );
IF Form_Failure OR Form_Fatal THEN
ABORT_QUERY;
END IF;
ELSE
/*
** Perform the default Oracle Forms task of opening the query.
*/
Select_Records;
END IF;