Use this function to get the total number of members for the named collection. If gaps exist, the total member count returned is not equal to the highest sequence ID in the collection. If the named collection does not exist for the current user in the current session, an error is raised.
APEX_COLLECTION.COLLECTION_MEMBER_COUNT ( p_collection_name IN VARCHAR2) RETURN NUMBER;
Table 7-6 COLLECTION_MEMBER_COUNT Function Parameters
The name of the collection.
This example shows how to use the
COLLECTION_MEMBER_COUNT function to get the total number of members in the
Begin l_count := APEX_COLLECTION.COLLECTION_MEMBER_COUNT( p_collection_name => 'DEPARTMENTS'); End;