Re: UTL_FILE access

Ari,

I believe the parameter in UTL_FILE_DIR and the value is the directory which the FOPEN will reference. You can even use "*" but it is not recommended for security reasons. I have found that the values for UTL_FILE_DIR are case-sensative - even on platforms such as WinNT. Also, if you specify a particular directory, you must also include the trailing delimiter (eg: "/usr/data/")

HTH
Mike Morgan

Ari Kaplan <akaplan_at_interaccess.com> wrote in article <5sfd0v$q86_at_nntp.interaccess.com>...
>
> 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.
>
> 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 <->
> <-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
>
>
Received on Fri Aug 08 1997 - 00:00:00 CEST