SQL>
SQL> CREATE OR REPLACE PROCEDURE get_line(file_in IN UTL_FILE.FILE_TYPE, line_out OUT VARCHAR2, eof_out OUT BOOLEAN)
2 IS
3 BEGIN
4 UTL_FILE.GET_LINE (file_in, line_out);
5 eof_out := FALSE;
6 EXCEPTION
7 WHEN NO_DATA_FOUND
8 THEN
9 line_out := NULL;
10 eof_out := TRUE;
11 END;
12 /
SQL>