Problems to create text files

From: Jean-Christophe MARTIN <dr_jcm_at_hotmail.com>
Date: Fri, 19 Nov 1999 12:32:27 +0100
Message-ID: <813cc3$44b$1_at_wanadoo.fr>



Hello!

[Quoted] [Quoted] We've got here a little problem in creating text files within an Oracle procedure using the fOpen command.

Running the following simple code, the answer is always 'invalid path'.

CREATE OR REPLACE PROCEDURE testp is
fileid utl_file.file_type ;
begin
fileid := utl_file.fopen('C:\Temp', 'test.sql', 'r') ; utl_file.put_line(fileid,'on est la') ;
utl_file.fclose(fileid) ;

exception
when utl_file.invalid_path then
DBMS_OUTPUT.put_line('invalid path') ;
Raise ;
End;

We have made sure than the parameter 'utl_file_dir=*' is present in the 'initorcl.ora' file (with the assistance of the Oracle HotLine) The problem is present on the Oracle server (PC) itself, so it cannot be an user authorization or net default.

If you have answers, please mail them to dr_jcm_at_hotmail.com.

Thanks a lot Received on Fri Nov 19 1999 - 12:32:27 CET

Original text of this message