FILEOPEN, OPEN v17

Suggest edits

The FILEOPEN and OPEN procedures open a BFILE for read-only purposes. 

FILEOPEN (<file_loc> IN OUT BFILE, 
   <open_mode> IN NUMBER := file_readonly)

OPEN (<file_loc> IN OUT BFILE, 
   <open_mode> IN NUMBER := file_readonly)

Parameters

file_loc

Locator for the BFILE.

open_mode

File can be accessed only in read-only mode.

Example

DECLARE
   /* Initialize the BFILE locator: */
   File_loc1 BFILE := BFILENAME('ANOTHER_DIR', 'a.txt');
BEGIN
   DBMS_LOB.FILEOPEN(File_loc1, DBMS_LOB.LOB_READONLY);
   DBMS_LOB.FILECLOSE(File_loc1);
END;
← Prev

FILEISOPEN, ISOPEN

↑ Up

DBMS_LOB

Next →

GET_STORAGE_LIMIT