Mega Code Archive

 

Categories / Oracle PLSQL / System Packages

 

ORA_DICT_OBJ_NAME_LIST

SQL> SQL> DECLARE   2    name_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_name_list(name_list);   7      dbms_output.put_line('counter:'||counter);   8    END IF;   9  END;  10  / PL/SQL procedure successfully completed. SQL> SQL>