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: UTL_FILE.INVALID_PATH

Re: UTL_FILE.INVALID_PATH

From: <suisum_at_freenet.edmonton.ab.ca>
Date: 16 Aug 1998 02:28:19 GMT
Message-ID: <6r5g43$rhi$2@news.sas.ab.ca>


Hi:

You may only write one entry in init.ora if you want to use widecard:

  utl_file_dir = *

Best regards,

Arjan van Bentem (avbentem_at_DONT-YOU-DAREdds.nl) wrote:
: >You will only be able to write to directories below /tmp/dat not above

: >You will only be able to access files using utl_file in directories
: >which are below /tmp/dat not above

: No, you should specify each directory explicitly. Oracle does not allow
: access to subdirectories of a given directory, unless explicitly specified.
: However, you may have more than one line for utl_file_dir in init.ora. Like:

: utl_file_dir = /tmp
: utl_file_dir = /tmp/dat
: utl_file_dir = /tmp/dat/outgoing
: utl_file_dir = /rje

: or, being lazy and maybe stupid:

: utl_file_dir = *
Received on Sat Aug 15 1998 - 21:28:19 CDT

Original text of this message

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