Not getting ORA-29285 - File write error (oracle) even the output file is incomplete
<p>I've a code in oracle to write data from database to a file.</p>

<pre><code>conn := utl_file.fopen('sample_directory','output.csv','W',32000);
for i in (select * from per_data)
loop
utl_file.put_line(conn,i.name||','||i.dept||','||to_char(i.start_date,'dd-mon-  yy')||','||to_char(i.expire_date,'dd-mon-yy')||','||i.loc||','||i.currently||','||i.past||','||i.sub1||','||i.sub2||','||i.sub3||','||i.sub4||','||i.sub5||','||i.sub6||','||i.sub7||','||i.sub8||','||i.sub9||','||i.sub10||','||i.sub11||','||i.sub12||','||i.sub13||','||i.total,TRUE);
end loop;
utl_file.fclose(conn);
EXCEPTION
WHEN OTHERS THEN
   dbms_output.Put_line('SQL Error' || SQLCODE || SQLERRM);
</code></pre>

<p>Oracle is not throwing <code>ORA-29285 - File write error</code> but I can see my output file to be incomplete.</p>

<p>Please Can someone help me out with this issue ?</p>

<p><strong>Edit:</strong> The same piece of code worked fine before I add two new columns to the output. I mean to say that I had been notified by Oracle that there was <code>file_write_error</code> whenever I have an incomplete file.</p>