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.