Oracle/PLSQL: BFilename Function

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

Syntax

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

• Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i

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;