title: how do I read a local file in SQL Developer?
body: <p>I want to read a file on my local machine that contains query parameters when I execute a query in Oracle SQL developer.  The examples that I've found on the web so far are inadequate.  I keep getting "ORA-29283: invalid file operation" errors when I execute the below code:</p>
  
  <pre><code>CREATE DIRECTORY SAMPLEDATA2 AS 'C:';
  GRANT READ, WRITE ON DIRECTORY SAMPLEDATA2 TO PUBLIC;
  
  
  declare
  f utl_file.file_type;
  s varchar2(200);
  c number := 0;
  
  BEGIN
  
  f := utl_file.fopen('SAMPLEDATA2','sample2.txt','R');
  loop
      utl_file.get_line(f,s);
      dbms_output.put_line(s);
      c := c + 1;
  end loop;
  
  exception
      when NO_DATA_FOUND then
          utl_file.fclose(f);
          dbms_output.put_line('Number of lines: ' || c);
  end;
  </code></pre>