Re: Help UTL_FILE utility

[Quoted] Do you have utl_file_dir set in your initxxx.ora file? If so, what version of the rdbms are you using? There are some inconsistancies in versions earlier than 7.3.3 which requires that you specify the path with an ending '/'. With 7.3.4 and later that is not necessary.

Ken

Sarma Kambhampati wrote:

> 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 - 20:01:19 CEST