Invalid filehandle error from utlfile * resolved *****

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Fri, 17 Aug 2007 12:10:01 -0400
Message-Id: <46C59019.3406.000B.0@gcrta.org>

Programming error.  

There was an "when others" exception handler which closed the file. It was within a loop and processing continued thus next write attempt failed.

++++++++++++++++++++++++++++++++

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

Received on Fri Aug 17 2007 - 11:10:01 CDT