From: terryg8 <trg@ibm.net>
Subject: Re: UTL_FILE access
Date: 1997/08/08
Message-ID: <33EB9604.8C3@ibm.net>#1/1
References: <33EA49C5.5B048E2B@NO_SPAM.nortel.com> <5sfd0v$q86@nntp.interaccess.com>
To: akaplan@interaccess.com
Reply-To: trg@ibm.net
Newsgroups: comp.databases.oracle.tools,comp.databases.oracle.misc



Ari Kaplan wrote:
> 
> Patrick Drouin (patrick.drouin@NO_SPAM.nortel.com) wrote:
> : Hello everyone,
> :  I'm trying to use the UTL_FILE modules but I can't get them to work.
> : How do I find out which directory are accessible to my packages and how
> : do I had some more if I need to? I'm trying to store some basic output
> : of SQL queries in an HTML file that could be refresh every day.
> : Any help is welcome,
> : Patrick
> 
> According to Steve Feuerstein's "PL/SQL Programming" book:
> "The location (of the file) you provide must have been listed as an
> accessible directory in the init.ora file for the database instance.
> When you pass the location as an argument to FOPEN, however, its format
> must differ slightly from the init.ora value."
> 
> What that init.ora parameter is, the book does not mention. I tried
> the bdump, cdump, and udump directories, to no avail.
> 
> Any suggestions out there?
> 
> -Ari Kaplan
> Independent Oracle DBA Consultant
> 
> <-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
> <-> For 100+ Oracle tips, visit my Web Page:                      <->
> <->                                                               <->
> <->             http://homepage.interaccess.com/~akaplan          <->
> <->                                                               <->
> <->             email: akaplan@interaccess.com                    <->
> <-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

I asked and received the answer to a similar question
on this groups a few weeks ago. Ain't it grand?
The init.ora parameter is "utl_file_dir"
Set it to a writable directory for the user of the 
utl_file package. i.e. utl_file_dir=/tmp
Cheers,
TRG