Re: Accessing files from PL/SQL

From: M Ivon M <i.p.kok02_at_kpn.com>
Date: Wed, 02 Feb 2000 14:18:41 GMT
Message-ID: <879eau$gfo$1@hdxl22.telecom.ptt.nl>

postbus_at_sybrandb.demon.nl (Sybrand Bakker) wrote:

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

>>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?

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

It looks like that's the problem. I assumed the dba _did_ set that parameter when he created the directory. When viewing the Oracle params in Toad, utl_file_dir doesn't contain the dir. I'll contact the dba (or whatever his function is :-).

Thanks to all who responded,
Ivon Received on Wed Feb 02 2000 - 08:18:41 CST