CREATE OR REPLACE procedure UTL_FUNCTION (test VARCHAR2) IS
 vInHandle  utl_file.file_type;
 vNewLine VARCHAR2(200);
BEGIN
  vInHandle := utl_file.fopen('C:\ORALOAD\', 'test.txt','r');

  IF utl_file.is_open(vInHandle ) THEN
    LOOP
      BEGIN
        utl_file.get_line(vInHandle , vNewLine);

        IF vNewLine IS NULL THEN
          EXIT;
        END IF;

      END;
    END LOOP;
END;

.

 FORGIVE ME with my ignorance, I dont know what's catproc.sql, what it does with Oracle.

Thanks for sharing your valuable time. I really appreciate it
.

ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at line 5

DECLARE
vInHandle utl_file.file_type;
vNewLine VARCHAR2(250);
BEGIN
vInHandle := utl_file.fopen('ORALOAD', 'test.txt', 'R');
LOOP
BEGIN
utl_file.get_line(vInHandle, vNewLine);
dbms_output.put_line(vNewLine);
--EXCEPTION
--WHEN OTHERS THEN
--EXIT;
END;
END LOOP;
utl_file.fclose(vInHandle);
END fopen;
/