title: Reading Text Document from PL/SQL stored procedure
body: <pre><code>CREATE OR REPLACE PROCEDURE file_trial IS
    V1 VARCHAR2(32767);
    F1 UTL_FILE.FILE_TYPE;
  BEGIN
    F1 := UTL_FILE.FOPEN('C:\TEMP','AVI','R',256);
    UTL_FILE.GET_LINE(F1,V1,32767);
   UTL_FILE.FCLOSE(F1);
  END file_trial;
  </code></pre>
  
  <p>This code while executing gives </p>
  
  <blockquote>
    <p>ORA 29280 : INVALID DIRECTORY PATH"</p>
  </blockquote>
  
  <p>But file (avi.txt) present in temp folder</p>