Read file : File Read with UTL_FILE « System Packages « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Packages
3. File Read with UTL_FILE

SQL>
SQL> CREATE OR REPLACE PROCEDURE readit
  2  IS
  3    v_filehandle_input UTL_FILE.FILE_TYPE;
  4    v_newline     VARCHAR2(32767);
  5  BEGIN
  6    v_filehandle_input := UTL_FILE.FOPEN('c:\temp','functions.sql', 'r', 32767 );
  7   loop
  8    BEGIN
  9      UTL_FILE.GET_LINE(v_filehandle_input,v_newline);
 10      DBMS_OUTPUT.PUT_LINE(v_newline);
 11    EXCEPTION
 12      WHEN NO_DATA_FOUND THEN EXIT ;
 13    END;
 14   end loop;
 15    UTL_FILE.FCLOSE (v_filehandle_input) ;
 16  end;
 17  /

Warning: Procedure created with compilation errors.

SQL> show errors
Errors for PROCEDURE READIT:

LINE/COL ERROR
-------- -----------------------------------------------------------------
3/22     PL/SQL: Item ignored
3/22     PLS-00201: identifier 'UTL_FILE' must be declared
6/3      PL/SQL: Statement ignored
6/3      PLS-00320: the declaration of the type of this expression is
         incomplete or malformed

9/5      PL/SQL: Statement ignored
9/23     PLS-00320: the declaration of the type of this expression is
         incomplete or malformed

15/3     PL/SQL: Statement ignored

LINE/COL ERROR
-------- -----------------------------------------------------------------
15/20    PLS-00320: the declaration of the type of this expression is
         incomplete or malformed

SQL>
SQL>
SQL>
SQL>