DBMS_SQLTUNE_INTERNAL invalid and trying to compile getting ORA-00904: XMLCONCAT: invalid identifier error (Doc ID 1912384.1)

Last updated on JULY 31, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 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

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