Oracle/PLSQL: BFilename Function

In Oracle/PLSQL, the bfilename function returns a BFILE locator for a physical LOB binary file.

The syntax for the bfilename function is:

bfilename( 'directory', 'filename' )

directory is a directory object that serves as an alias for the full path to where the file is located on the file server.

filename is the name of the file on the file server.

Applies To:

For example:

First, we need to create a directory object called exampleDir that points to /example/totn on the file server.

CREATE DIRECTORY exampleDir AS '/example/totn';

Then we can use the exampleDir directory object in the bfilename function as follows:

SELECT bfilename('exampleDir', 'totn_logo.jpg')
FROM dual;