bfilename returns a BFILE locator that is associated with a physical LOB binary file on the server's file system.

You must create the directory object and associate a BFILE value with a physical file before you can use them as arguments to bfilename in a SQL or PL/SQL statement, DBMS_LOB package, or OCI operation.

You can use this function in two ways:

The directory argument is case sensitive. That is, you must ensure that you specify the directory object name exactly as it exists in the data dictionary. For example, if an &Admin& directory object was created using mixed case and a quoted identifier in the CREATE DIRECTORY statement, then when using the bfilename function you must refer to the directory object as 'Admin'. You must specify the filename argument according to the case and punctuation conventions for your operating system.