Hi
We use htp.p a lot to send out JSON output through restful services (Oracle 11.2.0.4). The problem we occasionally encounter is the output is larger than the 32K limit that htp.p allows. In these cases we have procedures that loop through the CLOB and spit out the htp.p in chunks. The issues we have is that if you do this in an arbitrary way (say every 32K bytes) then the JSON can become invalid (to the receiver) as it seems that each htp.p process appends a CR/LF to the output. We have modified routines to chunk the output every time it sees a "safe" character, like '}' for example, but this is not fool proof as there are times when the gap between occurrences of this character are larger than 32K. I can't help but think there is an easier solution to all this that I'm missing. Any help appreciated
Thanks
Simon