How to validate the packages DBMS_METADATA_INT and DBMS_METADATA_UTIL
(Doc ID 1586673.1)
Last updated on FEBRUARY 03, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.3 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
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 |