Re: How to use UTL_FILE.FOPEN()
From: Stephen Wellman <swellman_at_chemware.com>
Date: Fri, 3 Mar 2000 16:47:31 -0500
Message-ID: <89pbqj$cmd$1_at_gaddy.interpath.net>
Date: Fri, 3 Mar 2000 16:47:31 -0500
Message-ID: <89pbqj$cmd$1_at_gaddy.interpath.net>
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. Received on Fri Mar 03 2000 - 22:47:31 CET