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

On-Count Trigger

Description

Fires when Oracle Forms would normally perform default Count Query processing to determine the number of rows in the database that match the current query criteria. When the On-Count trigger completes execution, Oracle Forms issues the standard query hits message: FRM-40355: Query will retrieve <n> records.

Definition Level form, block

Legal Commands

SELECT statements, PL/SQL, unrestricted Built-ins

Enter Query Mode yes

Usage Notes

On Failure

no effect

On-Count Trigger Example

This example calls a user-named subprogram to count the number of records to be retrieved by the current query criteria, and sets the Query_Hits property appropriately.

DECLARE
j NUMBER;
BEGIN
j := Recs_Returned('DEPT',Name_In('DEPT.DNAME'));
Set_Block_Property('DEPT',QUERY_HITS,j);
END;


COUNT_QUERY Built-in