Comment/CDATA/PI buffer overflow, maximum size is 4096 bytes
I have a table with containing a SYS.XMLType column into which I'm loading XML data -- by inserting a CLOB and then doing an UPDATE to set the SYS.XMLType column to be SYS.XMLType.createXML(clobColumn)
I've run into the following error:
ORA-19202: Error occurred in XML processing
LPX-00005: Comment/CDATA/PI buffer overflow, maximum size is 4096 bytes
Error at line 419
ORA-06512: at "SYS.XMLTYPE", line 0
ORA-06512: at line 1
Indeed, my XML does include a large amount of PI data. So, how do I increase this buffer or make it so the buffer grows as required?
This is under 9i release 9.2.0.1.0 on Solaris.
Any help much appreciated...
Richard