How to validate the packages DBMS_METADATA_INT and DBMS_METADATA_UTIL (Doc ID 1586673.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.
***Checked for relevance on 21-Sep-2016***

Goal

 The following objects were found invalid while querying dba_objects:


OWNER      OBJECT_NAME                    OBJECT_TYPE         STATUS
---------- ------------------------------ ------------------- -------
SYS        DBMS_METADATA_INT              PACKAGE BODY        INVALID
SYS        DBMS_METADATA_UTIL             PACKAGE BODY        INVALID

 

When trying to compile manually, you get the following errors:


SQL> alter package sys.dbms_metadata_util compile;

SP2-0809: Package altered with compilation warnings

SQL> show errors;
Errors for PACKAGE SYS.DBMS_METADATA_UTIL:

LINE/COL ERROR
-------- -----------------------------------------------------------------
130/9    PLW-06010: keyword "VALUE" used as a defined name
158/31   PLW-06010: keyword "TYPE" used as a defined name
211/17   PLW-06010: keyword "LENGTH" used as a defined name
214/17   PLW-06010: keyword "ROW" used as a defined name
229/17   PLW-06010: keyword "LENGTH" used as a defined name
232/17   PLW-06010: keyword "ROW" used as a defined name
245/17   PLW-06010: keyword "LENGTH" used as a defined name
248/17   PLW-06010: keyword "ROW" used as a defined name
261/17   PLW-06010: keyword "LENGTH" used as a defined name
264/17   PLW-06010: keyword "ROW" used as a defined name
281/17   PLW-06010: keyword "LENGTH" used as a defined name

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms