Invalid ORD_DICOM_ADMIN_PRV Package after Upgrade to Oracle Database 11g

Last updated on FEBRUARY 08, 2017

Applies to:

Symptoms

• After upgrade to Oracle Database 11g, the ORD_DICOM_ADMIN_PRV package in the ORDSYS schema is invalid.
• This has been seen in upgrades to 11.1.0.6, 11.1.0.7 and 11.2.0.x
• Trying to compile the package results in the below errors:
  
  Warning: Package Body created with compilation errors.
  
  Errors for PACKAGE BODY ORD_DICOM_ADMIN_PRV:
  
  LINE/COL ERROR
  -------- -----------------------------------------------------------------
  3794/7 PL/SQL: SQL Statement ignored
  3796/11 PL/SQL: ORA-00932: inconsistent datatypes: expected - got -
  3809/9 PL/SQL: SQL Statement ignored
  3811/13 PL/SQL: ORA-00932: inconsistent datatypes: expected - got -
  3824/9 PL/SQL: SQL Statement ignored
  3826/13 PL/SQL: ORA-00932: inconsistent datatypes: expected - got -

• Describing the ALL_XML_SCHEMAS view shows the following:

SQL> describe all_xml_schemas;
     Name                                      Null?    Type
     ----------------------------------------- -------- ------------- 
     OWNER                                              VARCHAR2
     SCHEMA_URL                                         VARCHAR2
     LOCAL                                              VARCHAR2
     SCHEMA                                             VARCHAR2
     INT_OBJNAME                                        VARCHAR2
     QUAL_SCHEMA_URL                                    VARCHAR2

• Selecting the view definition from DBA_VIEWS shows the below:

SQL> select text  from dba_views where view_name = 'ALL_XML_SCHEMAS';
    
    TEXT
    ------------------------------------------------------------------ 
    select null, null, null, null, null, null from dual where 1=0 
    

Changes

Upgraded to Oracle Database 11g

Cause