Re: UTL_FILE Woes

You have to run this procedure through oracle user where oracle is having DBA as group and Oracle as user a/c.

Hope will work, let me know if doesn't work.

Thanks,

Vrajesh.

Mike Criscolo wrote:

> Hello,
>
> I'm having a bit of a time getting the UTL_FILE package
> to work under Solaris 2.6. I'm running 7.3.4. I've set
> the utl_file_dir to most everything, including "*", "/tmp",
> and even the home directory of the "oracle" user. To
> no avail. When I run the proc, I get an exception that's
> NOT the standard exceptions thrown during a FOPEN call.
> I check for Invalid Path, Invalid Mode and Invalid Operation.
> I'm landing in the "WHEN OTHERS" clause of my EXCEPTION
> statement.
>
> This same proc runs fine under NT/7.3.4. Is there a trick to
> getting UTL_FILE working under UNIX?
>
> Thanks,
> -Mike
Received on Sat Apr 17 1999 - 11:53:20 CDT