Oracle SQL: the Essential Reference

BFILENAME

BFILENAME(directory, filename)

Returns a BFILE locator that points to a file that you specify.

Parameters

directory

Specifies a directory, previously created using the CREATE DIRECTORY statement that contains the file.

filename

Specifies a name of the file to which you want the locator to point. Note that you can create locators to files that do not exist.

Example

DECLARE
   admin_photo BFILE;
BEGIN
   admin_photo := BFILENAME('/home/oracle','administrator_  photo.jpg');
   ...
END;