Re: UTL_FILE package...need info

Ian Abramson wrote:
>
> I am running 73. on an IBM RS/6000. I want to be able to do file I/O in
> PL/SQL, and have installed and configured the UTL_FILE package.
>
> We have experienced some problems......
>
> The UTL_FILE_DIR = *
>
> This should mean that we can write to any directory...wrong!
>
> If we try to write to a user's directory, we get an error.
>
> ORA-6510 - PL/SQL unhandled user defined exception.
>
> This problem does not exist when we write to a dir under the Oracle home.
>
> Has ANYBODY used this package yet, if so could I get some guidance on the
> way that thing really work.
>
> Thanks,
>
> Ian Abramson
We have the same problem on Sun platform SunOs 5.5 . We have set the UTL_FILE_DIR = <our oracle home dir>. Even then we have the same error. Received on Thu Nov 14 1996 - 00:00:00 CET