SQL> CREATE TABLE myBFile
2 (id NUMBER PRIMARY KEY,
3 bfile_data BFILE);
Table created.
SQL>
SQL> DECLARE
2 bfileValue BFILE;
3 BEGIN
4 INSERT INTO myBFile VALUES (1,BFILENAME('BFILE_DIR','test.bmp'))
5 RETURNING bfile_data INTO bfileValue;
6
7 END;
8 /
PL/SQL procedure successfully completed.
SQL>
SQL> drop table myBFile;
Table dropped.
SQL>