UTL_FILE pkg and symbolically linked directories dont work

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 let me open a file under my home directory. I even tried specifying the full path and the symbolic path. I figured it is probably a security feature that prevents people from playing with directories that may be linked somewhere. I just wish there was some documentation tha mentioned this.

For some reason the PL/SQL guide doesn't describe the UTL_FILE package in detail. Applicatin Developer's Guide does. I wonder why. At least the PL/SQL guide could have said that I should go read Application Developer's guide to get more info. It wasn't until tkyte told me to go look it up there that I knew about it.

Atif Khan
aak2_at_ra.msstate.edu Received on Sun Apr 20 1997 - 00:00:00 CDT