apex delete collection
BEGIN
APEX_COLLECTION.DELETE_COLLECTION(p_collection_name => 'EMPLOYEE_CL');
-- All collections belonging to current session
APEX_COLLECTION.DELETE_ALL_COLLECTIONS_SESSION;
-- All collections belonging to current user
APEX_COLLECTION.DELETE_ALL_COLLECTIONS;
END;