title: Reading file from text file using pl/sql
body: <p>I want to read text file, store it in a variable and output the variable in pl/sql. I am using the following code but getting error:statement ignored.</p>
  
  <pre><code>create or replace PROCEDURE blah
  AS
  DECLARE
  f UTL_FILE.FILE_TYPE;
  s VARCHAR2(200);
  BEGIN
  f := UTL_FILE.FOPEN('C:\Users\s420105\Music','blahh.txt','R');
  UTL_FILE.GET_LINE(f,s);
  UTL_FILE.FCLOSE(f);
  dbms_output.put_line(s);
  END;
  </code></pre>
  
  <p>I am not sure about UTL permission but i suppose it will throw different error if it is due to UTL permission. The</p>