Re: UTL_FILE access

Ari Kaplan wrote:
>
> 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
>
> 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_at_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 Received on Fri Aug 08 1997 - 00:00:00 CDT