Returns the number of rows in the record group.
FUNCTION GET_GROUP_ROW_COUNT
(recordgroup_id RecordGroup);
FUNCTION GET_GROUP_ROW_COUNT
(recordgroup_name VARCHAR2);
Built-in Type unrestricted function
Returns NUMBER
Enter Query Mode yes
/*
** Built-in: GET_GROUP_ROW_COUNT
** Example: Determine how many rows were retrieved by a
** Populate_Group for a query record group.
*/
DECLARE
rg_id RecordGroup;
status NUMBER;
the_rowcount NUMBER;
BEGIN
rg_id := Create_Group_From_Query('MY_QRY_GROUP',
'SELECT ENAME,EMPNO,SAL FROM EMP ORDER BY SAL DESC');
status := Populate_Group( rg_id );
*/ *** Zero status is success*** /
IF status = 0 THEN
the_rowcount := Get_Group_Row_Count( rg_id );
Message('The query retrieved '||to_CHAR(the_rowcount)||
' record(s)');
ELSE
Message('Error creating query record group.');
RAISE Form_Trigger_Failure;
END IF;
END;