Oracle | ORDUTIL

Oracle ORDUTIL Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Undocumented

AUTHID CURRENT_USER

Dependencies

ALL_OBJECTS	ORDDOCEXCEPTIONS	ORDSOURCEEXCEPTIONS
DBMS_ASSERT	ORDIMERRORCODES	ORDUTIL

Documented No

Exceptions

Error Code	Reason
ORA-06510	PL/SQL: unhandled user-defined exception

First Available 12.1

Security Model Owned by ORDSYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/ordzpksp.plb

Subprograms

GETAUDIOPKGNAME	GETDOCPKGNAME	GETVIDEOPKGNAME
GETDICOMVALIDATION	GETSOURCEPKGNAME	SETDICOMVALIDATION

GETAUDIOPKGNAME

Undocumented ordutil.getAudioPkgName(format IN VARCHAR2) RETURN VARCHAR2;

conn ordsys

      Password:

      

      SELECT ordutil.getAudioPkgName('AIFC')

      FROM dual;

      SELECT ordutil.getAudioPkgName('ZZYZX')

      *

      ERROR at line 1:

      ORA-06510: PL/SQL: unhandled user-defined exception

      ORA-06512: at "ORDSYS.ORDIMERRORCODES", line 83

      ORA-06512: at "ORDSYS.ORDIMERRORCODES", line 65

      ORA-06512: at "ORDSYS.ORDIMERRORCODES", line 29

      ORA-06512: at "ORDSYS.ORDUTIL", line 138

GETDICOMVALIDATION

Undocumented ordutil.getDicomValidation RETURN NUMBER;

conn / as sysdba

      

      SELECT ordsys.ordutil.getDicomValidation

      FROM dual;

      SELECT ordsys.ordutil.getDicomValidation

      *

      ERROR at line 1:

      ORA-06598: insufficient INHERIT PRIVILEGES privilege

      ORA-06512: at "ORDSYS.ORDUTIL", line 1

      

      conn ordsys

      Password:

      

      SELECT ordsys.ordutil.getDicomValidation

      FROM dual;

      

      GETDICOMVALIDATION

      ------------------

                       1

GETDOCPKGNAME

Undocumented ordutil.getDocPkgName(format IN VARCHAR2) RETURN VARCHAR2;

TBD

GETSOURCEPKGNAME

Undocumented ordutil.getSourcePkgName(srctype IN VARCHAR2) RETURN VARCHAR2;

conn ordsys

      Password:

      

      SELECT ordsys.ordutil.getSourcePkgName('ORDAudio')

      FROM dual;

      SELECT ordsys.ordutil.getSourcePkgName('ORDAudio')

      *

      ERROR at line 1:

      ORA-06510: PL/SQL: unhandled user-defined exception

      ORA-06512: at "ORDSYS.ORDIMERRORCODES", line 83

      ORA-06512: at "ORDSYS.ORDIMERRORCODES", line 65

      ORA-06512: at "ORDSYS.ORDIMERRORCODES", line 29

      ORA-06512: at "ORDSYS.ORDUTIL", line 126

GETVIDEOPKGNAME

Undocumented ordutil.getVideoPkgName(format IN VARCHAR2) RETURN VARCHAR2;

conn ordsys

      Password:

      

      SELECT ordsys.ordutil.getVideoPkgName('MP4')

      FROM dual;

      SELECT ordsys.ordutil.getSourcePkgName('ORDAudio')

      *

      ERROR at line 1:

      ORA-06510: PL/SQL: unhandled user-defined exception

      ORA-06512: at "ORDSYS.ORDIMERRORCODES", line 83

      ORA-06512: at "ORDSYS.ORDIMERRORCODES", line 65

      ORA-06512: at "ORDSYS.ORDIMERRORCODES", line 29

      ORA-06512: at "ORDSYS.ORDUTIL", line 126

SETDICOMVALIDATION

Undocumented ordutil.setDicomValidation(validation_level IN NUMBER);

conn ordsys

      Password:

      

      exec ordsys.ordutil.setDicomValidation(1);

      

      PL/SQL procedure successfully completed.