BFILENAME

Syntax

bfilename::=

Text description of bfilename

Purpose

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

• 'directory' is a database object that serves as an alias for a full path name on the server's file system where the files are actually located
• 'filename' is the name of the file in 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, PL/SQL, DBMS_LOB package, or OCI operation.

See Also: Oracle9i Application Developer's Guide - Large Objects (LOBs) and Oracle Call Interface Programmer's Guide for more information on LOBs CREATE DIRECTORY

Examples

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:

CREATE DIRECTORY media_dir AS '/demo/schema/product_media';

INSERT INTO print_media (product_id, ad_id, ad_graphic)
   VALUES (3000, 31001, 

bfilename('media_dir', 'modem_comp_ad.gif'));