Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
Functions, 12 of 166
bfilename::=
bfilename
BFILENAME
returns a BFILE
locator that is associated with a physical LOB binary file on the server's file system. A directory is an alias for a full path name on the server's file system where the files are actually located, and 'filename' is the name of the file in the server's file system.
Neither 'directory' nor 'filename' needs to point to an existing object on the file system at the time you specify BFILENAME
. However, you must associate a BFILE
value with a physical file before performing subsequent SQL, PL/SQL, DBMS_LOB
package, or OCI operations.
See Also:
|
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:
INSERT INTO print_media (product_id, ad_id, ad_graphic) VALUES (3000, 31001, bfilename('/demo/schema/product_media', 'modem_comp_ad.gif')); 1 row created.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|