Oracle | ORD_DICOM

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	GENERATETAGLISTDOCUMENT	PUBLISHDATAMODEL
EDITDATAMODEL	GETDOCUMENTCONTENT	ROLLBACKDATAMODEL
EXPORTDOCUMENT	INSERTDOCUMENT

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