Re: Help UTL_FILE utility

Hi -

[Quoted] You may have the write permission problem even though the error message may not necessarily indicate it.

At least on our 7.3.3 UNIX release the utl files are written under user oracle.

You also want to make sure that you have the following line in your init.ora file and then stop and start the database for it to take effect. [Quoted] * means any directory/sub-directory where user oracle has permission to write a file.

  utl_file_dir = *

Later !!!

Suresh Bhat
Oracleguru
www.oracleguru.net
oracleguru_at_mailcity.com

Sarma Kambhampati <kbrsarma_at_hotmail.com> wrote in article <01bec7d4$5cf4e4e0$aa400828_at_KSarma.d51.lilly.com>...
> I'm getting 'INVALID PATH' error when running this code.
> All I'm trying to do is Open a file in Write mode and
> Close it!
> Any suggestions?
> Thanks
> Sarma
>
> SET SERVEROUTPUT ON
>
> DECLARE
> FILE_PTR UTL_FILE.FILE_TYPE;
> BEGIN
> FILE_PTR := UTL_FILE.FOPEN('c:\','temp.txt', 'w');
> EXCEPTION
> WHEN UTL_FILE.INVALID_PATH THEN
> DBMS_OUTPUT.PUT_LINE ('INVALID PATH');
> END;
> /
>
>
Received on Tue Jul 06 1999 - 23:03:10 CEST