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

  • From: "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx>
  • To: "oracle-l-freelists" <oracle-l@xxxxxxxxxxxxx>, "oracle-db-l" <oracle-db-l@xxxxxxxxxxxxxxxxxxxx>, "oracle tech-old list" <ORACLE-L@xxxxxxxxxxxxx>, "oracle rdbms group" <oracle-rdbms@xxxxxxxxxxxxxxx>
  • Date: Fri, 17 Aug 2007 12:10:01 -0400

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
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

Other related posts:

  • » Invalid filehandle error from utlfile * resolved *****