Insertar imagen en campo BLOB

[Linterns]

Un copy & Paste de lo que Oracle recomienda:

Table:
Test (id number, logo blob)

Here are the steps that I tried:
1. Create or replace directory MY_FILES as 'C:\images'

2. insert image procedure as follows:

create or replace procedure insert_img as
f_lob bfile;
b_lob blob;
begin
insert intotest (number, logo) values (8088, empty_blob())
return logo into b_lob;
f_lob :=bfilename('MY_FILES', 'act1.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;
/

NOTA: Verifica tus privilegios de Crear directorios virtuales