COLLECTION_EXISTS Function

Use this function to determine if a collection exists. A TRUE is returned if the specified collection exists for the current user in the current session for the current Application ID, otherwise FALSE is returned.

Syntax

APEX_COLLECTION.COLLECTION_EXISTS (
    p_collection_name IN VARCHAR2)
RETURN BOOLEAN;

Parameters

Table 4-4 describes the parameters available in the COLLECTION_EXISTS function.

---

Table 4-4 COLLECTION_EXISTS Function 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 shows how to use the COLLECTION_EXISTS function to determine if the collection named EMPLOYEES exists.

Begin
    l_exists := APEX_COLLECTION.COLLECTION_EXISTS (
        p_collection_name => 'EMPLOYEES';
End;