Definition:
The Oracle BFILENAME function returns a BFILE from a combination of a directory and a file name. The BFILE is a locator that is associated with a physical file on the server file system.
Example Syntax and Usage:
BFILENAME(directory IN VARCHAR2, filename IN VARCHAR2) RETURN BFILE;
DECLARE
src_file BFILE;
BEGIN
src_file := bfilename('CTEMP', 'myfile.txt');
END;
/
Note that 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 PL/SQL statement or DBMS_LOB package.
Related Links:
Related Code Snippets:
- BFILENAME - BFILENAME returns a BFILE locator that is associated with a physical LOB binary file ...
