Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_LOB , 11 of 26
This procedure determines the directory alias and filename, given a BFILE
locator. This function only indicates the directory alias name and filename assigned to the locator, not if the physical file or directory actually exists.
The maximum constraint values for the dir_alias
buffer is 30, and for the entire pathname is 2000.
DBMS_LOB.FILEGETNAME ( file_loc IN BFILE, dir_alias OUT VARCHAR2, filename OUT VARCHAR2);
Parameter | Description |
---|---|
file_loc |
Locator for the |
dir_alias |
Directory alias. |
filename |
Name of the |
Exception | Description |
---|---|
VALUE_ERROR |
Any of the input parameters are |
INVALID_ARGVAL |
|
CREATE OR REPLACE PROCEDURE Example_8 IS fil BFILE; dir_alias VARCHAR2(30); name VARCHAR2(2000); BEGIN IF (dbms_lob.fileexists(fil)) THEN dbms_lob.filegetname(fil, dir_alias, name); dbms_output.put_line("Opening " || dir_alias || name); dbms_lob.fileopen(fil, dbms_lob.file_readonly); -- file operations dbms_output.fileclose(fil); END IF; END;
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|