Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Failed to write to, flush, or close a file.

Victor Swindell2 days ago

I'm writing a PL/SQL Script to create a CSV file from tables in an Oracle DB.

One of the fields is a CLOB ..nothing insane. The largest one has 1423 characters.

Anyway, when I'm writing a file, when I get to this one field that has only 1007 characters.. I get the error.

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.

So far it only happend when I get to this field and not the previous one.
If I only process this field…I get the same error.

I'm stripping the data of any CRLF … any clue what's causing it.

Comments
Post Details
Added 2 days ago
2 comments
67 views