My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

Applies to:

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


@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:
-------- -----------------------------------------------------------------
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


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

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