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: Help: UTL_FILE package problem

Re: Help: UTL_FILE package problem

From: Jurij Modic <jmodic_at_src.si>
Date: Sun, 11 Jul 1999 22:18:53 GMT
Message-ID: <3788f702.33271388@news.siol.net>


On Sun, 11 Jul 1999 17:08:04 +0200, Graziano <g_nanetti_at_hotmail.com> wrote:

>Hi guys,
>I had a problem using the UTL_FILE package. In particular, when I try to
>open
>a file in an existing directory with the following instruction ...
>
>hFile := utl_file.fopen('e:\job\fiat\nscc', 'tabla025.txt', 'w');
>
>... I get an invalid path exception.
>What can I do?

Check the UTL_FILE_DIR parameter in your initSID.ora. It must be *exactly* the same as the path you are specifying in the UTL_FILE.FOPEN call. Even on NT it is case sensitive!

>Thanks in advance ;-)
>gn

HTH, Jurij Modic <jmodic_at_src.si>
Certified Oracle DBA (7.3 & 8.0 OCP)



The above opinions are mine and do not represent any official standpoints of my employer Received on Sun Jul 11 1999 - 17:18:53 CDT

Original text of this message

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