?? create_import_procedure.sql
字號:
-- Set Data Model Repository
execute ordsys.ord_dicom.setDataModel();
create or replace procedure image_import(dest_id number, filename varchar2) is
dcm ordsys.orddicom;
begin
delete from medical_image_table where id = dest_id;
insert into medical_image_table (id, dicom, imageThumb, anonDicom)
values (dest_id, ordsys.orddicom('file', 'IMAGEDIR', filename, 0),
ordsys.ordimage.init(), ordsys.orddicom())
returning dicom into dcm;
dcm.import(1);
update medical_image_table set dicom=dcm where id=dest_id;
commit;
end;
/
show errors;
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -