Failed to write to, flush, or close a file. in PL/SQL while trying to write csv file using UTL_FILE

Question

I am trying to create a CSV file of college courses for the current term from a Banner DB (Oracle) using PL/SQL. I’ve created lots of scripts to do this…and no had this issue before. I’ve spent over a week trying to see what is causing this and how to resolve it.

The query has about 376 returned rows. Line size is 32767 characters.

In addition to that, I have another table that has a description of the course. The data type of the description is a CLOB. The biggest value only had 1476 characters. The script will process until it gets to a particular course, and then it throws

Error report - ORA-29285: file write error ORA-06512: at "SYS.UTL_FILE", line 148 ORA-06512: at "SYS.UTL_FILE", line 889 ORA-06512: at line 272 29285. 00000 - "file write error" *Cause: Failed to write to, flush, or close a file. *Action: Verify that the file exists, that it is accessible, and that it is open in write or append mode.

The length of the description for this course is only 1007 characters. I’m stripping out all characters < ASCII(32).

If I go into the database table and look at the data for this course description, then only the characters I can see are 2 instances of CR LF. The file is being created up to this point…so it’s not an access issue.

I altered the query to only pull this course…and it immediately throws this error. What could be causing this…any help...MSG Me

You are exceeding the default max_linesize for a line of output. Provide a value for max_linesize in the call to utl_file.fopen that is large enough to hold the longest line of output. — Jason Seek Well
– Jason Seek Well, Commented Oct 7 at 20:40
NOPE: Max size limit of the line is 32767. The offending field only has 1007 characters. — vswindell
– vswindell, Commented Oct 9 at 13:32

vswindell · Accepted Answer · 2025-10-09 19:10:17Z

0

In the call to utl_file.fopen specify the MaxLine size...
if not you get a shorter line

answered Oct 9 at 19:10

vswindell

411 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Failed to write to, flush, or close a file. in PL/SQL while trying to write csv file using UTL_FILE

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related