I am using the function EXP_DATA created by Sloba
-- Version 1.0
It works perfect for 13 of my 14 files.
One of the files fails with ORA-29285: file write error
It does write 8 of the records to the file.
The first record that it fails on is 2113 in length - and the max length could potentially be around 10000 so I modified the fopen as follows:
l_output := utl_file.fopen( p_dir, p_filename, 'w',32767 ) - and the max individual column could be 1500 chars.
It still fails. I also removed all of the CHR(10) and CHR(13) from the fields. Any idea what could be wrong?
Thanks - cathie