Invalid XDB related Procedures SYS.XDB$MIGRATEXMLTABLE and SYS.CREATE_CSXINVALID_ENTRIES_TAB After Upgrade To 11g (Doc ID 868712.1)

Last updated on APRIL 29, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.2.0.2.0 [Release 11.1 to 11.2]
Information in this document applies to any platform.
Checked for relevance on 30-Apr-2013


Symptoms

XDB component was recently upgraded to the 11g database. There are now two invalid XDB related
procedures owned by SYS.

XDB$MIGRATEXMLTABLE
CREATE_CSXINVALID_ENTRIES_TAB

When trying to compile these objects the following is returned:

SQL> alter PROCEDURE XDB$MIGRATEXMLTABLE compile;

Warning: Procedure altered with compilation errors.

SQL> show error
Errors for PROCEDURE XDB$MIGRATEXMLTABLE:

LINE/COL ERROR
-------- -----------------------------------------------------------------
225/5 PL/SQL: Statement ignored
225/5 PLS-00905: object SYS.CREATE_CSXINVALID_ENTRIES_TAB is invalid
SQL> alter PROCEDURE CREATE_CSXINVALID_ENTRIES_TAB compile;

Warning: Procedure altered with compilation errors.

SQL> show error
Errors for PROCEDURE CREATE_CSXINVALID_ENTRIES_TAB:

LINE/COL ERROR
-------- -----------------------------------------------------------------
151/7 PL/SQL: Statement ignored
151/7 PLS-00201: identifier 'XDB.FIXACL_SCHEMALOC' must be declared

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