这个跟Domino环境没有什么关系吧。下面是一个用存储过程把你的图片放到blob字段中的例子: SQL> create directory MYDIR as 'C:\MYIMAGE';Directory created.SQL> create table special(a number, b varchar2(20), c blob);Table created.SQL> insert into special values(1,'abcd',empty_blob()); 1 row created.SQL> commit;Commit complete.#用记事本创建文件:blob_insert.sql create or replace procedure load(id number) is dest_lob blob; src_lob bfile:=bfilename('MYDIR','img.bmp'); amt integer:=sys.dbms_lob.getlength(src_lob); begin select c into dest_lob from special where a=id for update; dbms_lob.fileopen(src_lob); dbms_lob.loadfromfile(dest_lob,src_lob,amt); dbms_lob.fileclose(Src_lob); commit; end; /SQL> @ blob_insertProcedure created.SQL> exec load(1);PL/SQL procedure successfully completed.如果你将你的图片的名称跟记录关键字(如员工编号)关联的话,用存储过程很容易就能实现你要的结果。
SQL> create directory MYDIR as 'C:\MYIMAGE';Directory created.SQL> create table special(a number, b varchar2(20), c blob);Table created.SQL> insert into special values(1,'abcd',empty_blob()); 1 row created.SQL> commit;Commit complete.#用记事本创建文件:blob_insert.sql
create or replace procedure load(id number)
is
dest_lob blob;
src_lob bfile:=bfilename('MYDIR','img.bmp');
amt integer:=sys.dbms_lob.getlength(src_lob);
begin
select c into dest_lob from special
where a=id for update;
dbms_lob.fileopen(src_lob);
dbms_lob.loadfromfile(dest_lob,src_lob,amt);
dbms_lob.fileclose(Src_lob);
commit;
end;
/SQL> @ blob_insertProcedure created.SQL> exec load(1);PL/SQL procedure successfully completed.如果你将你的图片的名称跟记录关键字(如员工编号)关联的话,用存储过程很容易就能实现你要的结果。