FILECLOSE, CLOSE v17
The FILECLOSE
and CLOSE
procedures close an open BFILE.
FILECLOSE (<file_loc> IN OUT BFILE) CLOSE (<file_loc> IN OUT BFILE)
Parameters
file_loc
Locator for the BFILE.
Example
DECLARE /* Initialize the BFILE locator: */ File_loc1 BFILE := BFILENAME('ANOTHER_DIR', 'a.txt'); BEGIN DBMS_LOB.OPEN(File_loc1, DBMS_LOB.LOB_READONLY); /* Close the BFILE: */ DBMS_LOB.FILECLOSE(File_loc1); END;
- On this page
- Parameters
- Example