Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Problems to create text files

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@wanadoo.fr>


Hello!

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 - 05:32:27 CST

Original text of this message

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