RE: Invalid filehandle error from utlfile

There are some limitations with UTL_FILE.  

You need to flush the output buffer (utl_file.fflush) before its filled over 32kB and need to include a linefeed ( \n ) in your data that a row would not become larger than 1024 bytes (if i recall correctly). Also you may need to write rows longer than 255 chars in multiple separate write calls as a single call ( tu utl_file.putf at least ) did not support output strings longer than 256 chars.  

I write this from memory, might not be entierly accurate, but yes the utl_file is a pain...  

Tanel.  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jeffrey Beckstrom
Sent: Friday, August 17, 2007 02:56
To: oracle-l-freelists; oracle-db-l; oracle tech-old list; oracle rdbms group
Subject: Invalid filehandle error from utlfile

We are getting the invalid_filehandle error after outputting a dozen rows of data. The error started after an extra column was added to the output line. This column is coming from a table. If we hard code the entry in place of the database column - it works. However, if use the database column we get the error. We do get output for some and then hit the row that is causing a problem. What conditions would cause this kind of error.    

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113

--
http://www.freelists.org/webpage/oracle-l