SQL> create directory MYDIR as 'C:\MYIMAGE';Directory created.SQL> create table special(a number, b varchar2(20), c blob);Table created.SQL> SQL> insert into special values(1,'abcd',empty_blob()); 1 row created.SQL> SQL> commit;Commit complete. create or replace procedure load(id number) is dest_lob blob; src_lob bfile:=bfilename('MYDIR','file.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> insert into special values(1,'abcd',empty_blob()); 1 row created.SQL>
SQL> commit;Commit complete.
create or replace procedure load(id number)
is
dest_lob blob;
src_lob bfile:=bfilename('MYDIR','file.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.