COLLECTION_HAS_CHANGED Function

15.6 COLLECTION_HAS_CHANGED Function

Determines if a collection has changed since it was created or since the collection changed flag was reset.

Syntax

APEX_COLLECTION.COLLECTION_HAS_CHANGED (
    p_collection_name   IN VARCHAR2 )
RETURN BOOLEAN;

Parameters

Parameter	Description
`p_collection_name`	The name of the collection. An error is returned if this collection does not exist with the specified name of the current user and in the same session.

Example

The following example determines if the EMPLOYEES collection has changed since it was created or last reset.

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

Parent topic: APEX_COLLECTION