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

Does oracle have write priviledges for the home directories in question.

Just out of curiosity, what kind of RS6000 are you using and what version of AIX are you using.

thanx Received on Wed Nov 13 1996 - 00:00:00 CET