UTL_FILE Woes

From: Mike Criscolo <mike_at_accretive.com>
Date: Fri, 2 Apr 1999 22:59:54 -0500
Message-ID: <7e43nu$arg$1@camel15.mindspring.com>

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 Fri Apr 02 1999 - 21:59:54 CST