title: reading and writing text files using UTL_FILE package remotely
body: <p>I 'am trying to read and write files using utl_file package remotely but the oracle server cant read and write on other pc ,so i make a shared path on '\\adel-pc\test', and i want to read and write on that path but i get this error when reading  :</p>
  
  <pre><code>SQL Error [29283] [99999]: ORA-29283: invalid file operation
  ORA-06512: at "SYS.UTL_FILE", line 536
  ORA-29283: invalid file operation
  ORA-06512: at line 8
  
    java.sql.SQLException: ORA-29283: invalid file operation
  ORA-06512: at "SYS.UTL_FILE", line 536
  ORA-29283: invalid file operation
  ORA-06512: at line 8
  </code></pre>
  
  <p>and this error when writing :</p>
  
  <pre><code>SQL Error [29283] [99999]: ORA-29283: invalid file operation
  ORA-06512: at "SYS.UTL_FILE", line 536
  ORA-29283: invalid file operation
  ORA-06512: at line 7
  
    java.sql.SQLException: ORA-29283: invalid file operation
  ORA-06512: at "SYS.UTL_FILE", line 536
  ORA-29283: invalid file operation
  ORA-06512: at line 7
  </code></pre>
  
  <p>and this is my code  :</p>
  
  <pre><code>CREATE OR REPLACE DIRECTORY utl_test AS '\\10.10.60.11\test'; 
  
  
  
  
  -- reading the file
  DECLARE 
  p_dir varchar2(2000):='UTL_TEST';
  p_file_name varchar2(2000):='IFD18021801IFEEDTL'; --file name
  l_file UTL_FILE.file_type; 
  l_text varchar2(32767);
  begin
  l_file := UTL_FILE.fopen(p_dir,p_file_name,'r');
  
  LOOP
  UTL_FILE.get_line(l_file,l_text);
  DBMS_OUTPUT.put_line(l_text);
  END LOOP;
  
  UTL_FILE.fclose(l_file);
  
  EXCEPTION
  WHEN UTL_FILE.invalid_operation THEN dbms_output.PUT_LINE('cannot open file invalid name');
  WHEN UTL_FILE.read_error THEN dbms_output.PUT_LINE('cannot be read');
  WHEN no_data_found THEN dbms_output.PUT_LINE('end of file');
  
  UTL_FILE.fclose(l_file);
  END;
  
  
  
  
  --writing the file
  declare 
  l_file UTL_FILE.file_type;
  l_location varchar2(100) := 'UTL_TEST'; -- capital latter
  l_filename varchar2(100) := 'am';
  
  begin
  l_file := UTL_FILE.fopen(l_location,l_filename,'w');
  
  FOR i IN (SELECT * FROM hr.EMPLOYEES)
  LOOP
  UTL_FILE.PUT_LINE(l_file,i.EMPLOYEE_ID||'     '||i.FIRST_NAME);
  END LOOP;
  UTL_FILE.fclose(l_file);
  
  l_file := UTL_FILE.fopen(l_location,l_filename,'A');
  UTL_FILE.PUT_LINE(l_file,'Additonal lines');
  UTL_FILE.fclose(l_file);
  
  END;
  </code></pre>
  
  <p>so my questions are: </p>
  
  <ul>
  <li><p>could I write and read on the shared path or it cant be done using utl_file ?</p></li>
  <li><p>why I am getting this error , knowing that I gave read &amp; write permissions to that path.          </p></li>
  </ul>