create or replace directory my_files as 'c:/test';


declare
  f_lob bfile;
  b_lob blob;
begin
  insert into emp1(empno,empname,resume) values ( 1001, 'BILLGATES',empty_blob())
  return resume into b_lob;
-- resume is the field name in my table which has BLOB data type
  f_lob := bfilename( 'MY_FILES', 'Purchase.doc' );
  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;