ORDIM and ORD_DICOM_ADMIN_PRV package body are INVALID (Doc ID 1385299.1)

Last updated on AUGUST 17, 2015

Applies to:

Oracle Multimedia - Version 11.2.0.2 to 11.2.0.2 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 17-Aug-2015***

Symptoms

Oracle Multimedia (ORDIM) is INVALID.

SQL> SELECT comp_id, status, version, comp_name
  2  FROM dba_registry
  3  WHERE comp_id = 'ORDIM';

COMP_ID      STATUS     VERSION    COMP_NAME
------------ ---------- ---------- ----------------------------------------
ORDIM        INVALID    11.2.0.2.0 Oracle Multimedia

 

DBA_OBJECTS shows ORDSYS.ORD_DICOM_ADMIN_PRV package body is INVALID.

SQL> SELECT OWNER, OBJECT_NAME, OBJECT_TYPE
  2  FROM DBA_OBJECTS
  3  WHERE STATUS = 'INVALID'
  4  ORDER BY OWNER, OBJECT_NAME, OBJECT_TYPE;

OWNER                OBJECT_NAME                    OBJECT_TYPE
-------------------- ------------------------------ -------------------
ORDSYS               ORD_DICOM_ADMIN_PRV            PACKAGE BODY

 

DBA_ERRORS show the compilation errors for ORDSYS.ORD_DICOM_ADMIN_PRV.

SQL> SELECT e.owner, e.name, TO_CHAR(e.line) || '/' ||
2 TO_CHAR(e.position) "POSITION", e.text
3 FROM dba_errors e
4 ORDER BY e.owner, e.name, e.sequence;

OWNER   NAME                POSITION TEXT
------- ------------------- -------- ------------------------------------------------
ORDSYS  ORD_DICOM_ADMIN_PRV 4969/26 PLS-00302: component 'VALID_STR_VALUES' must be declared
ORDSYS  ORD_DICOM_ADMIN_PRV 4969/13 PL/SQL: Statement ignored
ORDSYS  ORD_DICOM_ADMIN_PRV 4980/26 PLS-00302: component 'VALID_STR_VALUES' must be declared
ORDSYS  ORD_DICOM_ADMIN_PRV 4980/13 PL/SQL: Statement ignored
ORDSYS  ORD_DICOM_ADMIN_PRV 4990/46 PLS-00302: component 'VALID_STR_VALUES' must be declared
ORDSYS  ORD_DICOM_ADMIN_PRV 4990/13 PL/SQL: Statement ignored
ORDSYS  ORD_DICOM_ADMIN_PRV 4993/46 PLS-00302: component 'VALID_STR_VALUES' must be declared
ORDSYS  ORD_DICOM_ADMIN_PRV 4993/13 PL/SQL: Statement ignored

 

A DESC of ORDDATA.ORDDCM_PREFS_LOOKUP shows the object exists.  However, granting a privilege on this object to ORDSYS fails.

SQL> desc ORDDATA.ORDDCM_PREFS_LOOKUP
Name                                      Null? Type
----------------------------------------- -------- ----------------------------
PARAM_NAME                                NOT NULL VARCHAR2(64)
PARAM_TYPE                                NOT NULL VARCHAR2(15)
MIN_VAL                                            NUMBER
MAX_VAL                                            NUMBER
DEFAULT_NUMBER_VAL                                 NUMBER
DEFAULT_STR_VAL                                    VARCHAR2(1999)
PARAM_DESC                                         VARCHAR2(4000)

SQL> grant ALTER ON ORDDATA.ORDDCM_PREFS_VALID_VALUES_TAB TO ORDSYS;
grant ALTER ON ORDDATA.ORDDCM_PREFS_VALID_VALUES_TAB TO ORDSYS
*
ERROR at line 1:
ORA-22812: cannot reference nested table column's storage table

 

The following query returns no rows:

SQL> select owner, table_name, nested from dba_tables
  2 where table_name in ('ORDDCM_PREFS_DEF_VALUES_TAB','ORDDCM_PREFS_VALID_VALUES_TAB');

no rows selected

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms