Steps required for Oracle Multimedia to export Images

Source: Internet
Author: User

How Does Oracle Multimedia export images? What code is required in the actual operation process? If you want to know about these problems, you can browse the following articles and hope you will gain some benefits.

Using the Oracle Multimedia export method to export DICOM data in the database requires the database to write data to the file system of the database server. Writing to a file system requires that you grant the write permission to the user PM user on the directory object in which the output DICOM file is written.

Perform the following steps:

1. Create a process to export DICOM data to a file in the IMAGEDIR directory. Execute the following script from the SQL * Plus session:

 
 
  1. @create_export_proc  

The create_export_proc. SQL code is as follows:

Java code

 
 
  1. create or replace procedure dicom_export (source_id number, filename varchar2) as   
  2. dcmSrc ordsys.orddicom;   
  3. begin   
  4. select dicom into dcmSrc from medical_image_table where id = source_id;   
  5. dcmSrc.export('FILE', 'IMAGEDIR', filename);   
  6. end;   
  7. /   
  8. show errors;   
  9. create or replace procedure dicom_export (source_id number, filename varchar2) as  
  10. dcmSrc ordsys.orddicom;  
  11. begin  
  12. select dicom into dcmSrc from medical_image_table where id = source_id;  
  13. dcmSrc.export('FILE', 'IMAGEDIR', filename);  
  14. end;  
  15. /  
  16. show errors;   

2. Now you can execute the process. Run the following command from the SQL * Plus session:

Java code

 
 
  1. execute dicom_export(1, 'dicom_orig.dcm');   
  2. execute dicom_export(1, 'dicom_orig.dcm');  
  3.  

3. Check the created file, open another terminal window, and execute the following command in the IMAGEDIR directory.

Java code

 
 
  1. ls -al dicom_orig.dcm   

The above is an introduction to the actual image export procedure in Oracle Multimedia. I hope you will find some gains.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.