Xref: alice comp.databases.oracle.misc:52350
Path: alice!news-feed.fnsi.net!newsfeed.icl.net!newspeer.clara.net!news.clara.net!news-x.support.nl!transit.news.cuci.nl!cleanfeed.casema.net!news1.kpn.net!news.unisource.nl!news.kpn.com!hdxl22.telecom.ptt.nl!not-for-mail
From: i.p.kok02@kpn.com (M Ivon M)
Newsgroups: comp.databases.oracle.misc
Subject: Re: Accessing files from PL/SQL
Date: Wed, 02 Feb 2000 14:18:41 GMT
Organization: KPN Telecom
Lines: 22
Message-ID: <879eau$gfo$1@hdxl22.telecom.ptt.nl>
References: <879b95$89k$1@hdxl22.telecom.ptt.nl> <38983822.9903594@news.demon.nl>
X-Trace: hdxl22.telecom.ptt.nl 949501086 16888 172.21.42.182 (2 Feb 2000 14:18:06 GMT)
X-Complaints-To: usenet@kpn.com
NNTP-Posting-Date: 2 Feb 2000 14:18:06 GMT
X-Newsreader: Forte Free Agent 1.0.82

postbus@sybrandb.demon.nl (Sybrand Bakker) wrote:

>On Wed, 02 Feb 2000 13:25:57 GMT, i.p.kok02@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