1、建立圖片目錄

create or replace directory "images" as 'e:\pic\';

2、建立儲存過程

CREATE OR REPLACE PROCEDURE img_insert ( filename VARCHAR2)AS

f_lob BFILE;

b_lob BLOB;

BEGIN

INSERT INTO image (image)

VALUES (EMPTY_BLOB () )return image into b_lob;

f_lob:=bfilename('images',filename);

dbms_lob.fileopen(f_lob,dbms_lob.file_readonly);

dbms_lob.loadfromfile(b_lob,f_lob,

dbms_lob.getlength(f_lob));

dbms_lob.fileclose(f_lob);

commit;

end;

/

3、執行儲存過程

exec img_insert('xxx.jpg')

oracle 載入圖片檔案

相關文章