Use this procedure to create a collection. If a collection exists with the same name for the current user in the same session for the current Application ID, all members of the collection are removed. In other words, the named collection is truncated.
APEX_COLLECTION.CREATE_OR_TRUNCATE_COLLECTION( p_collection_name IN VARCHAR2);
Table 7-8 CREATE_OR_TRUNCATE_COLLECTION Procedure Parameters
The name of the collection. The maximum length is 255 characters. All members of the named collection are removed if the named collection exists for the current user in the current session.
This example shows how to use the
CREATE_OR_TRUNCATE_COLLECTION procedure to remove all members in an existing collection named
Begin APEX_COLLECTION.CREATE_OR_TRUNCATE_COLLECTION( p_collection_name => 'EMPLOYEES'); End;