From: member46199@dbforums.com   
      
   Originally posted by Julia Sats   
      
   >   
      
   > and for line        my_file := utl_file.fopen(f_loc, f_out,   
   > f_mode, f_len);   
      
   > I got such error:   
      
   > ERROR at line 1:   
      
   > ORA-29280: invalid directory path   
      
   > ORA-06512: at "SYS.UTL_FILE", line 18   
      
   > ORA-06512: at "SYS.UTL_FILE", line 424   
      
   > ORA-06512: at "SCOTT.OUT_TEST", line 11   
      
   > ORA-06512: at line 1   
      
   >   
      
   >   
      
   > Can anybody propose what to do   
      
   >   
      
   > Thanks   
      
      
      
   I had the same problem. This is how I managed it:   
      
   - connect to the database as SYSDBA.   
      
   - go to "Instance\Configuration" -> "All Initialization   
     Parameters..." button   
      
   - choose "SPFile" radiobutton and scroll to "utl_file_dir" parameter   
      
   - here, write in "Value" field the directory you want to use (i.e.   
     C:\my_dir)   
      
   - apply and... voila! must work now   
      
      
      
   Good luck!   
      
      
   --   
   Posted via http://dbforums.com   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)