title: not able to write a big size data with UTL_FILE.PUT_LINE
body: <p>I created a xml which includes a big amount of data. Now I am trying to write that generated xml  into a file.  </p>
  
  <p>Declaration:</p>
  
  <pre><code>prodFeed_file  UTL_FILE.FILE_TYPE;
  prodFeed_file := UTL_FILE.FOPEN ('CSV_DIR', 'feed.xml', 'w', 32767); 
  </code></pre>
  
  <p>WRITING INTO FILE: </p>
  
  <pre><code>UTL_FILE.PUT_LINE(prodFeed_file,l_xmltype.getClobVal);
  
  UTL_FILE.FCLOSE(prodFeed_file);
  </code></pre>
  
  <p>If <code>l_xmltype.getClobVal</code> returns limited record then it is working file but if the <code>l_xmltype.getClobVal</code> exceeds the size(almost 35 KB) it is giving an error:</p>
  
  <p><code>ORA-06502: PL/SQL: numeric or value error</code></p>