Oracle9i SQL Reference Release 2 (9.2) Part Number A96540-01 |
|
Functions, 12 of 177
bfilename::=
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 locatedfilename
' is the name of the file in the server's file systemYou 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:
|
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'));
|
Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. |
|