|Oracle9i SQL Reference
Release 1 (9.0.1)
Part Number A90125-01
Functions, 12 of 166
BFILENAME returns a
BFILE locator that is associated with a physical LOB binary file on the server's file system. A directory is an alias for a full path name on the server's file system where the files are actually located, and 'filename' is the name of the file in the server's file system.
Neither 'directory' nor 'filename' needs to point to an existing object on the file system at the time you specify
BFILENAME. However, you must associate a
BFILE value with a physical file before performing subsequent SQL, PL/SQL,
DBMS_LOB package, or OCI operations.
The following example inserts a row into the sample table
pm.print_media. The example uses the
BFILENAME function to identify a binary file on the server's file system: