fil i blob

Sample program:
----------------
Step 1.
-------

Create a table to store the blobs:

create table blobs
( id varchar2(255),
blob_col blob
);


Step 2.
-------

Create a logical directory in the database to the physical file system:

create or replace directory MY_FILES as \'c:\\images\';


Step 3.
-------

Create a procedure to load the blobs from the file system using the logical
directory. The gif \"aria.gif\" must exist in c:\\images.

create or replace procedure insert_img as
f_lob bfile;
b_lob blob;
begin
insert into blobs values ( \'MyGif\', empty_blob() )
return blob_col into b_lob;

f_lob := bfilename( \'MY_FILES\', \'aria.gif\' );
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;
/