My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.