PL-SQL code to read a file

1DECLARE
2   fHandler   UTL_FILE.FILE_TYPE;
3
4   buf        VARCHAR2 (4000);
5BEGIN
6   fHandler := UTL_FILE.FOPEN ('STUDENT_DIR', 'Details.txt', 'r');
7
8   UTL_FILE.GET_LINE (fHandler, buf);
9
10   DBMS_OUTPUT.put_line ('DATA FROM FILE: ' || buf);
11
12   UTL_FILE.FCLOSE (fHandler);
13EXCEPTION
14   WHEN UTL_FILE.invalid_path
15   THEN
16      raise_application_error (
17         -20000,
18         'Invalid path. Create directory or set UTL_FILE_DIR.');
19END;
20/