From: akaplan@interaccess.com (Ari Kaplan)
Subject: Re: UTL_FILE access
Date: 1997/08/08
Message-ID: <5sfd0v$q86@nntp.interaccess.com>#1/1
References: <33EA49C5.5B048E2B@NO_SPAM.nortel.com>
Followup-To: comp.databases.oracle.tools,comp.databases.oracle.misc
Organization: InterAccess, Co. - Chicagoland's Full Service Internet Provider
Reply-To: akaplan@interaccess.com
Newsgroups: comp.databases.oracle.tools,comp.databases.oracle.misc



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                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->