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
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.

Related Topics
Built-in Functions
Built-in Packages
Database Security
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx