XML Database (MOSC)

MOSC Banner

After reinstalling XDM, got invalid package XDB.DBMS_RESCONFIG

edited Dec 5, 2011 6:26AM in XML Database (MOSC) 2 comments
Hi all,I did deinsall and reinstall XDB because of some unknown WH issue that could relate to XDB.

When I verify the XDB objects I found invalid object DBMS_RESCONFIG:

SQL> alter PACKAGE XDB.DBMS_RESCONFIG compile BODY;

Warning: Package Body altered with compilation errors.

SQL> show errors
Errors for PACKAGE BODY XDB.DBMS_RESCONFIG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
67/8     PL/SQL: SQL Statement ignored
69/26    PL/SQL: ORA-00932: inconsistent datatypes: expected REF got CHAR
179/8    PL/SQL: SQL Statement ignored
181/26   PL/SQL: ORA-00932: inconsistent datatypes: expected REF got CHAR

What is the cause of that datatype error?

Any help please?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center