Oracle ORD_DICOM_ADMIN
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 Provides the admin interface for the DICOM repository
AUTHID CURRENT_USER
Constants
Name Data Type Value
 General
DT_URL VARCHAR2(700) 'xmlns:dt="http://xmlns.oracle.com/ord/dicom/datatype_1_0"'
STORED_TAGLIST_DOC_SET VARCHAR2(64) 'USER'
DMDL_DOC_SET VARCHAR2(64) 'USER'
Dependencies
 ORDSOURCEEXCEPTIONS UTL_FILE XMLTYPE
Documented No
First Available Not known
Security Model Owned by ORDSYS with no EXECUTE granted to PUBLIC
Source {ORACLE_HOME}/ord/im/admin/ordcrpsp.sql
Subprograms
 
DELETEDOCUMENT
Documents installed by Oracle cannot be removed and delete of dictionary documents is not supported in this release ord_dicom_admin.deleteDocument(docname IN VARCHAR2);
conn / as sysdba

exec ordsys.ord_dicom_admin.deleteDocument('TESTDOC');
BEGIN ordsys.ord_dicom_admin.deleteDocument('TESTDOC'); END;
*
ERROR at line 1:
ORA-06598: insufficient INHERIT PRIVILEGES privilege
ORA-06512: at "ORDSYS.ORD_DICOM_ADMIN", line 1
ORA-06512: at line 1

conn ordsys
Password:

exec ordsys.ord_dicom_admin.deleteDocument('TESTDOC');
BEGIN ordsys.ord_dicom_admin.deleteDocument('TESTDOC'); END;
*
ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "ORDSYS.ORD_DICOM_ADMIN", line 84
ORA-06512: at line 1
 
EDITDATAMODEL
Locks the data model and starts the data model edits ord_dicom_admin.editDataModel;
exec ordsys.ord_dicom_admin.editDataModel;
BEGIN ordsys.ord_dicom_admin.editDataModel; END;
*
ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "ORDSYS.ORD_DICOM_ADMIN", line 95
ORA-06512: at line 1
 
EXPORTDOCUMENT
Export the document to a file specified by filename in the location specified by dirname ord_dicom_admin.exportDocument(
docname  IN VARCHAR2,
dirname  IN VARCHAR2,
filename IN VARCHAR2);
exec ordsys.ord_dicom_admin.exportDocument('TESTDOC', 'DOCDIR', 'testdoc.txt');
BEGIN ordsys.ord_dicom_admin.exportDocument('TESTDOC', 'DOCDIR', 'testdoc.txt'); END;
*
ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "ORDSYS.ORD_DICOM_ADMIN", line 74
ORA-06512: at line 1
 
GENERATETAGLISTDOCUMENT
Generates the STORED_TAG_LIST document as XMLType ord_dicom_admin.generateTagListDocument(
docset IN VARCHAR2 DEFAULT stored_taglist_doc_set) RETURN PUBLIC.XMLTYPE;
TBD
 
GETDOCUMENTCONTENT
Returns the configuration document as an XMLType ord_dicom_admin.getDocumentContent(docname IN VARCHAR2) RETURN PUBLIC.XMLTYPE;
exec ordsys.ord_dicom_admin.getDocumentContent('TESTDOC')
FROM dual;
BEGIN ordsys.ord_dicom_admin.getDocumentContent('TESTDOC'); END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00221: 'GETDOCUMENTCONTENT' is not a procedure or is undefined
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
 
INSERTDOCUMENT
Loads a single document of the specified docType into repository ord_dicom_admin.insertDocument(
docname IN VARCHAR2,
doctype IN VARCHAR2,
xmldoc  IN public.xmltype);
TBD
 
PUBLISHDATAMODEL
Commits changesm unlocks the data model, and publishes the new data model ord_dicom_admin.publishDataModel;
exec ordsys.ord_dicom_admin.publishDataModel;
BEGIN ordsys.ord_dicom_admin.publishDataModel; END;
*
ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "ORDSYS.ORD_DICOM_ADMIN", line 106
ORA-06512: at line 1
 
ROLLBACKDATAMODEL
Aborts changes to the data model and unlocks the data model ord_dicom_admin.rollbackDataModel;
exec ordsys.ord_dicom_admin.rollbackDataModel;
BEGIN ordsys.ord_dicom_admin.rollbackDataModel; END;
*
ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "ORDSYS.ORD_DICOM_ADMIN", line 117
ORA-06512: at line 1

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