15.5 COLLECTION_EXISTS Function

Determines if a collection exists. Returns TRUE if the specified collection exists for the current user in the current session for the current application ID, otherwise FALSE.

Syntax

APEX_COLLECTION.COLLECTION_EXISTS (
    p_collection_name   IN VARCHAR2 )
RETURN BOOLEAN;

Parameters

Parameter	Description
p_collection_name	The name of the collection. Maximum length is 255 bytes. The collection name is not case-sensitive and is converted to upper case.

Example

The following example determines if the collection named EMPLOYEES exists.

BEGIN
    l_exists := APEX_COLLECTION.COLLECTION_EXISTS (
        p_collection_name => 'EMPLOYEES');
END;