BFILE type variable : BFILE « PL SQL Data Types « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. PL SQL Data Types
3. BFILE

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>