Oracle ORDUTIL

Oracle ORDUTIL Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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;

SELECT 
      ordutil.getDocPkgName('???')

      FROM dual;

      SELECT ordutil.getDocPkgName('???')

      *

      ERROR at line 1:

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

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

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.