|Oracle9i SQL Reference
Release 2 (9.2)
Part Number A96540-01
Functions, 12 of 177
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.
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,