R: SYS.UTL_FILE Package

you have to put in the init.ora the parameter:

 utl_file_directory = *
 or
utl_file_dir (I don't remember very well)

Like this the function fopen can writing in your path.

bigrez <resnimi_at_mail.northgrum.com> wrote in message Fp0nxx.CoE%mother_at_herald.northgrum.com...
> I had a similar problem. Everything was correct and it should have
worked.
> I was running the PL/SQL program via Oracle's Web App Server. The DAD was
> set up and using the ORACLE_SID value for the database. In order for it to
> work though, I had to change the DAD to use the SQL*Net V2 service rather
> than the ORACLE_SID name. Once I did that, it worked perfectly!
>
>
> miaemp_at_my-deja.com wrote in message <86ku9r$rih$1_at_nnrp1.deja.com>...
> >I wrote a PL/SQL utility to output Stored Database Code. I am getting
> >an exception of INVALID PATH from the package when I go to open the
> >file. For example:
> >fin := fopen('/home/user/source',
> > 'test.pls',
> > 'w');
> >Does anyone have any ideas?
> >
> >TIA
> >Eric Peterson
> >Programmer/Analyst DBA
> >Maurices Inc.
> >eric_NOpeterson_at_mauriesSPAMMERS.inrg.com
>
>
>
Received on Wed Feb 09 2000 - 13:30:47 CST