Mega Code Archive
ORA_DICT_OBJ_OWNER_LIST returns the number of elements in the list indexed by a PLS_INTEGER datatype
SQL>
SQL> DECLARE
2 owner_list DBMS_STANDARD.ORA_NAME_LIST_T;
3 counter PLS_INTEGER;
4 BEGIN
5 IF ora_sysevent = 'ASSOCIATE_STATISTICS' THEN
6 counter := ora_dict_obj_owner_list(owner_list);
7 dbms_output.put_line('counter:'||counter);
8 END IF;
9 END;
10 /
PL/SQL procedure successfully completed.
SQL>