UTL_FILE.IS_OPEN : UTL_FILE « System Packages « Oracle PL/SQL Tutorial

SQL>
SQL> CREATE OR REPLACE PROCEDURE utlfile_test
  2  IS
  3    v_filehandle UTL_FILE.FILE_TYPE;
  4    v_newline VARCHAR2(1022);
  5  BEGIN
  6    IF NOT UTL_FILE.IS_OPEN(v_filehandle) THEN
  7      v_newline := 'This is the line of text';
  8
  9    END IF;
 10
 11  END;
 12  /


SQL> drop procedure utlfile_test;

Procedure dropped.

SQL>
SQL>

31.38.UTL_FILE
	31.38.1.	File open and close with UTL_FILE package
	31.38.2.	File open flags
	31.38.3.	Save table records to a file
	31.38.4.	Use UTL_FILE package to create a file
	31.38.5.	Open a file with mode passed in
	31.38.6.	utl_file.invalid_&&firstparm
	31.38.7.	UTL_File related exception
	31.38.8.	UTL_FILE.IS_OPEN
	31.38.9.	A PL/SQL block to read an operating system file called BLOB.JPG that contains 1 row of binary data.