Create a BFILE locator : BFILE « Large Objects « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Large Objects
3. BFILE

SQL>
SQL> CREATE TABLE facebook (
  2     name VARCHAR2(80),
  3     photo BLOB,
  4     directions CLOB,
  5     description NCLOB,
  6     web_page BFILE);

Table created.

SQL>
SQL> CREATE DIRECTORY bfile_data AS 'c:\xxx';

Directory created.

SQL>
SQL>
SQL> DECLARE
  2     web_page BFILE;
  3  BEGIN
  4     DELETE FROM facebook WHERE name='Tannery Falls';
  5
  6     web_page := BFILENAME('BFILE_DATA','Tannery Falls.htm');
  7
  8     INSERT INTO facebook (name, web_page) VALUES ('Tannery Falls',web_page);
  9  END;
 10  /

PL/SQL procedure successfully completed.

SQL>
SQL>
SQL> drop table facebook;

Table dropped.

SQL> drop directory bfile_data;

Directory dropped.

SQL>