Invalid ORD_DICOM_ADMIN_PRV Package after Upgrade to Oracle Database 11g
(Doc ID 604055.1)
Last updated on FEBRUARY 08, 2019
Applies to:
Oracle Multimedia - Version 11.1.0.6.0 and laterInformation in this document applies to any platform.
***Checked for relevance on 31-Oct-2012***
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |