DBMS_SQLPA ORA-00904 OTHER_XML invalid identifier (Doc ID 605317.1)

Last updated on DECEMBER 25, 2011

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.1.0.6 - Release: 10.2 to 11.1
Information in this document applies to any platform.
RDBMS 10.2.X

Symptoms

@Checked for relevancy 23-August-2010.

After applying one off patch 6903335 on 10.2.0.x required for SQL performance analyzer,
the DBA may get the following error while running @prvtspao.plb as per README of one patch 6903335.


prvtspao.plb script created package body DBMS_SQLPA with following compilation errors:
LINE/COL ERROR
-------- -----------------------------------------------------------------
123/5 PL/SQL: SQL Statement ignored
129/44 PL/SQL: ORA-00904: "OTHER_XML": invalid identifier

 

The README states:

# Patch Special Instructions:
# ---------------------------
# cd $ORACLE_HOME/rdbms/admin
# sqlplus / as sysdba
# drop table plan_table$; -- drop the plan table if was upgraded.
# @catplan.sql -- recreate the plan table
# @dbmsxpln.sql -- reload dbms_xplan spec
# @prvtxpln.plb -- reload dbms_xplan implementation
# @prvtspao.plb -- reload dbms_sqlpa
#

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