Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle BFILENAME Function      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

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      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 85 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?