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>