Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Use of utl_file in ORACLE 7.3.3

Re: Use of utl_file in ORACLE 7.3.3

From: Mark Hunter <mark[at]se7en[dot]demon[dot]co[dot]uk>
Date: Sun, 15 Nov 1998 19:52:00 GMT
Message-ID: <364f2bb0.36591814@news.demon.co.uk>


Have you checked the value of the parameter 'utl_file_dir' in init{SID}.ora? The file you are trying to write to must pattern match this variable. To write to 'any' location with utl_file, set this parameter to * (asterisk). File writes are only then permitted/denied by the operating system permissions.

Mark Hunter,
Gosforth, Newcastle, UK Received on Sun Nov 15 1998 - 13:52:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US