FILECLOSEALL v17

The FILECLOSEALL procedure closes all BFILEs opened in the current session.

FILECLOSEALL 

Example

DECLARE
   /* Initialize the BFILE locator: */
   File_loc1       BFILE := BFILENAME('ANOTHER_DIR', 'a.txt');
   File_loc2       BFILE := BFILENAME('ANOTHER_DIR', 'b.txt');
BEGIN
   DBMS_LOB.OPEN(File_loc1, DBMS_LOB.LOB_READONLY);
   DBMS_LOB.OPEN(File_loc2, DBMS_LOB.LOB_READONLY);
   /* Close the BFILEs: */
   DBMS_LOB.FILECLOSEALL();
END;