Mega Code Archive

 

Categories / Oracle PLSQL / System Packages

 

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> SQL> SQL>