Mega Code Archive
Read file
<![CDATA[
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>
]]>