Re: UTL_FILE access

[Quoted] [Quoted] Patrick Drouin (patrick.drouin_at_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

[Quoted] 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."

[Quoted] 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
[Quoted] Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 100+ Oracle tips, visit my Web Page:                      <->
<->                                                               <->
<->             http://homepage.interaccess.com/~akaplan          <->
<->                                                               <->
<->             email: akaplan_at_interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->