Re: utl_file.fopen and Oracle v9

From: abulafia <member46199_at_dbforums.com>
Date: Wed, 29 Oct 2003 10:09:59 -0500
Message-ID: <3536139.1067440199_at_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
Received on Wed Oct 29 2003 - 16:09:59 CET

Original text of this message