Xref: alice comp.databases.oracle.tools:40631
Path: alice!news-feed.fnsi.net!newsfeed.icl.net!newsfeed.icl.net!nntp.news.xara.net!xara.net!gxn.net!interpath.net!not-for-mail
From: "Stephen Wellman" <swellman@chemware.com>
Newsgroups: comp.databases.oracle.tools
Subject: Re: How to use UTL_FILE.FOPEN()
Date: Fri, 3 Mar 2000 16:47:31 -0500
Organization: ChemWare, Inc.
Lines: 25
Message-ID: <89pbqj$cmd$1@gaddy.interpath.net>
References: <1caf4cbd.a75d1091@usw-ex0104-033.remarq.com> <952119344.29605.1.pluto.d4ee154e@news.demon.nl>
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600

You need an initialization parameter that allows you to write to a
directory.

UTL_FILE_DIR

Parameter type:   string

Parameter class:   static

Default value:   none

Range of values:   any valid directory path

UTL_FILE_DIR allows database administrators to specify directories that are
permitted for PL/SQL file I/O. Each directory must be specified with a
separate UTL_FILE_DIR parameter in the INIT.ORA file.

Note that all users can read or write all files specified in the
UTL_FILE_DIR parameter(s). This means that all PL/SQL users must be trusted
with the information in the directories specified by the UTL_FILE_DIR
parameters.