UTL_FILE Problems/limitations

From: bhogak <bhogak_at_yahoo.com>
Date: Fri, 30 Mar 2001 21:45:42 -0600
Message-ID: <9a3k36$hud$1@bob.news.rcn.net>

Hello:
I am having problems using UTL_FILE.PUT procedure. I need to write a very long string to a file. At the time of opening the file, I am using the following syntax as per Oracle doc to specify a large buffer: myFile := UTL_FILE.FOPEN('/home/bhogak','abc.txt','W',32767). (I am sure that my string is less than 32k).

However, this doesn't work. I get a User-Defined Error. It took a while for me to figure out that PUT is not working. When I use PUT_LINE, I don't have any problems.

Did you have any problems like this before? If not, do you know anyway to remove new line character from a file within PL/SQL.

Thx.
bhogak Received on Fri Mar 30 2001 - 21:45:42 CST