After reinstalling XDM, got invalid package XDB.DBMS_RESCONFIG
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?
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?
0