I am trying to write a large file from a CLOB variable to an XML using UTL_FILE dir. I am getting ORA-06502: PL/SQL: numeric or value error at UTL_FILE.put. When I researched I found that UTL_FILE throws an exception for a large CLOB while writing. I am unable to find an alternate solution. Could you please let me know if there is a way to write a large XML using UTL_FILE or any other alternative?
Thanks in advance!