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;