如何使用PLSQL向ORACLE里插入图片?
麻烦的一笔 2007-10-25 11:07:59 能不能把每个步骤都写出来呢?
create table my_diagrams (chapter_descr varchar2(40), diagram_no integer, diagram blob);
create directory images as 'e:\images';
commit;
set serveroutput on
declare
l_bfile bfile;
l_blob blob;
begin
insert into my_diagrams (diagram)
values (empty_blob())
return diagram into l_blob;
l_bfile := bfilename ('images','\1.jpeg');
dbms_lob.open(l_bfile, dbms_lob.file_readonly);
dbms_lob.loadfromfile(l_blob,l_bfile,dbms_lob.getlength(l_bfile));
dbms_lob.close(l_bfile);
commit;
end;
我这里的为什么有错误?还有当我执行create directory images as 'e:\images';语句后为什么没有在硬盘相应路径下生成目录呢?请各位高手帮忙!