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>
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.comReceived on Wed Oct 29 2003 - 16:09:59 CET