Executes the query associated with the given record group and returns a number indicating success or failure of the query. Upon a successful query, POPULATE_GROUP returns a 0 (zero). An unsuccessful query generates an ORACLE error number that corresponds to the particular SELECT statement failure. The rows that are retrieved as a result of a successful query replace any rows that exist in the group.
POPULATE_GROUP is necessary to populate a record group before using the SET_TREE_PROPERTY(RECORD_GROUP) option.
Note: Be aware that the POPULATE_GROUP array fetches 100 records at a time. To improve network performance, you may want to restrict queries, thus limiting network traffic.
FUNCTION POPULATE_GROUP
(recordgroup_id RecordGroup);
FUNCTION POPULATE_GROUP
(recordgroup_name VARCHAR2);
Built-in Type unrestricted function
Returns NUMBER
Enter Query Mode yes
When the Populate_Group Built-in fails because the record group does not exist, a NULL value is returned.
Valid only for record groups:
/*
** Built-in: POPULATE_GROUP
** Example: See GET_GROUP_ROW_COUNT and CREATE_GROUP_FROM_QUERY
*/