My understanding is that UTL_FILE only works on the server. You can't let
Oracle read from and write to a file on your client PC running Windows
across the network. If you client is an NFS UNIX client, it may work.
Anyway, it's worth to try setting utl_file_dir to * (temporarily) in
init.ora and see if anything works.
Yong Huang
yhuang_at_indigopool.com
Mark D Powell <markp7832_at_my-deja.com> wrote in message
news:8qaiqa$o5a$1_at_nnrp1.deja.com...
> In article <8qai64$ndb$1_at_nnrp1.deja.com>,
> pequeberto_at_my-deja.com wrote:
> > Hi all!
> >
> > I'm trying to write a PL/SQL program using the package UTL_FILE, but I
> > can't open de file (using the function fopen). The problem seems to be
> > the path, because it always jump to the 'INVALID_PATH' exception. Do
> > you have any example of a program that uses this function?
> > I think I've tried all type of strings to change the path: 'D:\', 'D',
> > 'D:/', 'D:\\', '/home', ...
> >
> > Thanks in advance.
> >
> What version of Oracle are you using. I know with versions 7.3 and 8
> that utl_file only reads/writes to files on the database server. The
> directories that the files are in must be authorized for use via the
> ult_file_dir init.ora parameter. Did you authorize your directories?
>
> --
> Mark D. Powell -- The only advice that counts is the advice that
> you follow so follow your own advice --
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Sep 20 2000 - 00:00:00 CDT
