Quick Search:
 
 The Oracle BFILENAME Function      [Return To Index] Jump to:  

Term: BFILENAME

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 ...
 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org