Re: Accessing files from PL/SQL

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 02 Feb 2000 13:59:44 GMT
Message-ID: <38983822.9903594@news.demon.nl>

On Wed, 02 Feb 2000 13:25:57 GMT, i.p.kok02_at_kpn.com (M Ivon M) wrote:

>Hi all,
>
>I'm using the UTL_FILE package to open a file:
>Logfile := utl_file.fopen('d:\debug', 'log.txt', 'a')
>The d:\debug directory exists on the server, but utl_file raises the
>'invalid path' exception.
>
>What might be the problem?
>
>tia,
>Ivon
>

Maybe the utl_file_dir parameter in your init<sid>.ora has not been set. Check this, possibly change it and bounce the database.

Hth,

Sybrand Bakker, Oracle DBA Received on Wed Feb 02 2000 - 07:59:44 CST