FILEGETNAME v17

Suggest edits

The FILEGETNAME procedure obtains the directory alias and filename for a BFILE locator. This procedure doesn't determine whether the physical file or directory actually exists.

FILEGETNAME (<file_loc> IN BFILE, <dir_alias> OUT VARCHAR2, 
   <filename> OUT VARCHAR2)

Parameters

file_loc

Locator for the BFILE.

dir_alias

Alias for the directory.

filename

Name of the BFILE.

Example

DECLARE
    File_loc BFILE := BFILENAME('ANOTHER_DIR', 'a.txt');
    dir_alias VARCHAR2(30);
    name VARCHAR2(2000);
BEGIN
    DBMS_LOB.FILEGETNAME(File_loc, dir_alias, name);
    DBMS_OUTPUT.PUT_LINE('File - ' || dir_alias || name);
END;
← Prev

FILEEXISTS

↑ Up

DBMS_LOB

Next →

FILEISOPEN, ISOPEN