Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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-lReceived on Thu Aug 16 2007 - 19:23:54 CDT
![]() |
![]() |