Naidu. Kondisetty

• Aug 22nd, 2005

 

Yes there is a facility UTL_FILE , using this package you can read and write data into text files. 
Or TEXT_IO package also there.

Subhash

• Sep 1st, 2005

 

UTL_FILE is for backend procedures and this writes and reads from DB server , while TEXT_IO package is used in forms to read and write from Client machine

kameshakundy

 Profile Answers by kameshakundy Questions by kameshakundy

• Jun 22nd, 2006

 

In case if you are trying to do the same in Web Deployment then you need to use CLIENT_IO package which is being bundled with WEBUTIL package (in 9i or Higher Versions).

kameshakundy

 Profile Answers by kameshakundy Questions by kameshakundy

• Jun 22nd, 2006

 

the CLIENT_IO is just a replacement for TEXT_IO since the client-server mechanism is becoming obselete

dmdevaraj

 Profile Answers by dmdevaraj 

• Apr 29th, 2008

 

To write

Declare
T_filename Text_Io.File_Type;
w_NewLine    varchar2(200);
Begin
T_filename := Text_Io.Fopen('c:test.txt', 'W');
Text_Io.Put_Line(T_filename,'this is test');
Text_Io.Fclose(T_filename);
End;

To Read
Begin
T_filename := Text_Io.Fopen('c:test.txt', 'R');
Text_IO.Get_Line(w_FileHandle, w_NewLine);
Text_Io.Fclose(T_filename);
End;