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;
- On this page
- Example