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')
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26764973/viewspace-1173613/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26764973/viewspace-1173613/