Re: UTL_FILE.INVALID

From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Fri, 14 Aug 1998 18:55:40 +0200
Message-ID: <6r1q53$f14$1@newton.a2000.nl>

>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 = *

Arjan. Received on Fri Aug 14 1998 - 11:55:40 CDT

Re: UTL_FILE.INVALID_PATH