oracle 处理二进制文件

 create table image_lob(t_id varchar2(5) not null,t_image blob not null); 
  
 create or replace directory "images" as 'e:\pic\'; 
  
 create or replace procedure img_insert(tid varchar2,filename varchar2)as 
     f_lob bfile; 
    b_lob blob; 
   
    begin 
    insert into image_lob(t_id,t_image) 
    values(tid,empty_blob())return t_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;

call img_insert('1','Qxi.png');

查看结果:
select * from image_lob;