Re: utl_file.fopen and Oracle v9

[abulafia]

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