Re: Problems to create text files

From: Holger Kramer <hk_at_coin.de>
Date: Fri, 19 Nov 1999 13:10:15 +0100
Message-ID: <813en8$l6v$1@donau.aball.de>

Hi!

Jean-Christophe MARTIN schrieb in Nachricht <813cc3$44b$1_at_wanadoo.fr>...

: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') ;
maybe you should use 'w' as file open flag to allow writing to the file? otherwise oracle is searching for test.sql which was not yet created...

bye, holger Received on Fri Nov 19 1999 - 06:10:15 CST