My Oracle Support Banner

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

Last updated on JULY 16, 2019

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

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
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.