要写一段存储过程。比较麻烦。

你看能借鉴多少。

create or replace procedure dd (newid number)

as

blob_loc blob;

handle utl_file.file_type;

pic_length int;

amount int;

offset int:=1;

buffer raw(30000);

temp int;

newname varchar2(40);

begin

select name,pic into newname,blob_loc from sskb where id=newid;

pic_length:=dbms_lob.getlength(blob_loc);

handle:=utl_file.fopen('USER_DIR',newname||'.jpg','wb');

temp:=trunc((pic_length-1)/1000)+1;

for i in 1..temp

loop

if i!=temp

then amount:=1000;

else

amount:=pic_length-(temp-1)*1000;

end if;

dbms_lob.read(blob_loc,amount,offset,buffer);

offset:=offset+1000;

utl_file.put_raw(handle,buffer);

end loop;

utl_file.fclose(handle);

end;

/