Re: utl_file woes

Daniel, Thanks for trying to help.
after all of that and 2 days of a bloody forehead I found the typo in the filename. Now it works. As always with programming, look for the simple answer first.

with head hanging in disgust at self.
Eric

Daniel Morgan wrote:

> Eric Kimble wrote:
>
> > platform nt 4.0 sp6a
> > version 8.1.7.3 EE
> >
> > When trying to use utl_file I get an "Invalid Operation" error. in
> > reading the newsgroup posts and metalink posts this is due to
> > permissions not being set for the user or for the ult_file_dir not being
> > set in init.ora. I have verified those items and still getting invalid
> > operation error. So as it stands I have the permissions set to everybody
> > full control (is on a testing server), and utl_file_dir = * (again
> > testing so no big security risk). I have been able to make this work on
> > Win2k but can't get it to work on NT 4.0. I have also change to
> > utl_file_dir to the main path that i'm working in ( trying to read the
> > alert.log) so c:\oracle817 and restarted the server and the listener,
> > but am still getting the error. Any other suggestions?
>
> Permission to write to the directory is permission of the owner of the
> Oracle software ... not permissions for the user.
>
> Make sure that if you log on to the server as the user that installed the
> Oracle software you can write to that directory.
>
> If yes and it still deoen't workt ... post your init.ora and your code.
>
> Daniel Morgan
Received on Tue Oct 08 2002 - 21:58:31 CEST