Having Problem creating XML file from a clob, that size is larger than 32767
We are able to create a XML file that originates from a CLOB. We try to write the file using UTL.FILE utility's . There is a limit of 32767 per "line". I found some code that was handling this for a BLOB and made changes to apply to a CLOB.
BUt the problem is, when it breaks the file into "chunks" to write it, it is putting a carrage return in the middle of TAGS. Is there any way around this, or are we using the wrong method to write the file.
Here is the procedure that i have to handle larger CLOB's, but the carriage return is being written where we dont want it.