Re: UTL_FILE pkg and symbolically linked directories dont work

From: Cleve <cleve_at_cbcsf.org>
Date: 1997/04/21
Message-ID: <01bc4e59$d2bba520$666482d0@cbcsf1.techlink.net>#1/1

Atif Ahmad Khan <aak2_at_Ra.MsState.Edu> wrote in article <5jceen$8bu$1_at_NNTP.MsState.Edu>...
>
> My home directory on a Solaris X86 2.5.1. machine is under /home/atif
> which is a link to /opt/home/atif
>
> I spent last 2 days trying to figure out why I couldn't compile any of
> my PL/SQL code that used UTL_FILE package using any directory under my
> home. And then I tried /tmp and it all started working. Just to make
> sure I tried several directories under my home directory again with and
> without FULL read-write permissions. But no go. Nothing I do will
<<<CUT>>>
> I just wish there was some documentation tha mentioned
> this.

<<<CUT>>>
> Atif Khan
> aak2_at_ra.msstate.edu
>

I am not an Oracle expert but I believe that you may need to place the following in your init.ora file:

	utl_file_dir = /home/atif                // or whatever

Just a stab in the dark here.

Cleve Received on Mon Apr 21 1997 - 00:00:00 CDT