DBMS_SQLTUNE_INTERNAL invalid and trying to compile getting ORA-00904: XMLCONCAT: invalid identifier error
(Doc ID 1912384.1)
Last updated on APRIL 12, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.1 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud 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
Information in this document applies to any platform.
Symptoms
DBMS_SQLTUNE_INTERNAL is invalid and when trying to compile, it is failing with below error:
SQL> alter package DBMS_SQLTUNE_INTERNAL compile body;
Warning: Package Body altered with compilation errors.
SQL> show error
Errors for PACKAGE BODY DBMS_SQLTUNE_INTERNAL:
LINE/COL ERROR
-------- -----------------------------------------------------------------
8245/5 PL/SQL: SQL Statement ignored
8251/18 PL/SQL: ORA-00904: "XMLCONCAT": invalid identifier
8251/18 PLS-00306: wrong number or types of arguments in call to
'XMLCONCAT'
8292/5 PL/SQL: SQL Statement ignored
8296/27 PL/SQL: ORA-00904: "XMLCONCAT": invalid identifier
8296/27 PLS-00306: wrong number or types of arguments in call to
'XMLCONCAT'
Note 1271490.1 is followed and dropped XMLCONCAT public synonym but still getting same errors while compiling DBMS_SQLTUNE_INTERNAL
Cause
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
Symptoms |
Cause |
Solution |
References |