Home » SQL & PL/SQL » SQL & PL/SQL » UTL_FILE, read and write the same file
UTL_FILE, read and write the same file [message #36025] Tue, 30 October 2001 11:08 Go to next message
jeje
Messages: 9
Registered: October 2001
Junior Member
I recently use UTL_FILE and it works as well. But now I want to read a file until the sixth line and to modify that line.
If I use UTL_FILE.FOPEN with parameter 'R', I couldn't modify the sixth line. If I use UTL_FILE.FOPEN with parameter 'W', I couldn't use UTL_FILE.GET_LINE to change line in the file.

Help me please. Sorry for my poor english.

----------------------------------------------------------------------
Re: UTL_FILE, read and write the same file [message #36178 is a reply to message #36025] Thu, 08 November 2001 09:27 Go to previous message
hello
Messages: 17
Registered: November 2001
Junior Member
I don't know if i got ur problem right.

Here is an idea. Why don't u open the file with 'R' get the line save it in temp variable.

close the file

Modify

open file as 'W' and write the changes.

----------------------------------------------------------------------
Previous Topic: How to open wrapped packages???
Next Topic: Calling a stored procedure from a PL/SQL block
Goto Forum:
  


Current Time: Thu Apr 25 14:44:51 CDT 2024