Invalid SYS.DBMS_ODM After Upgrade To 10G

Last updated on APRIL 27, 2012

Applies to:

Symptoms

You upgraded from 9i  to 10g and you now have invalid sys.DBMS_ODM package body.


alter package sys.DBMS_ODM compile body;

Warning: Package Body altered with compilation errors.

SQL> show error
Errors for PACKAGE BODY SYS.DBMS_ODM:

0/0 PL/SQL: Compilation unit analysis terminated
1/14 PLS-00304: cannot compile body of 'DBMS_ODM' without its
specification

Package has no body in SYS

BUT :
select owner, object_name, object_type, status
f rom dba_objects
where object_name = 'DBMS_ODM';

returns the following:

SYS DBMS_ODM PACKAGE BODY INVALID
PUBLIC DBMS_ODM SYNONYM VALID
OLAPSYS DBMS_ODM PACKAGE VALID
OLAPSYS DBMS_ODM PACKAGE BODY VALID

Changes

Upgraded your database. This could also occur with new installation.

Cause