Oracle | DBMS_TYPE

Oracle DBMS_TYPE_UTILITY Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose The package was deprecated in 18c. It used to provide routines to compile all types and reset types during downgrade. Now it doesn't appear to do anything except waste electrons.

AUTHID DEFINER

Dependencies

STANDARD (only)

Documented No

First Available Not known

Pragma PRAGMA SUPPLEMENTAL_LOG_DATA(default, NONE);

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/dbmstypu.sql

NONE

From Oracle Development: "I am removing all procedure from the package as they are no longer in use and they have too many security holes to leave around. Keeping the package for possible future use." dbms_type_utility.none;

SQL> exec dbms_type_utility.none;

      

      PL/SQL procedure successfully completed.