Hi ,
I have a xml > 32 KB stored in a clob colum in oracle 10g , i am trying to extract the values by using the below piece of code
DECLARE
v_clob CLOB;
v_xml_type XMLTYPE;
BEGIN
select XML_CONTENT INTO v_clob from table1 ;
v_xml_type:=XMLTYPE(v_clob);
I am trying to parse and extract values using XMLTable and inserting values in other table but when parsing through XMLTYPE it is throwing me below error
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00216: invalid character 0 (0x0)
Error at line 1
ORA-06512: at "SYS.XMLTYPE", line 254
ORA-06512: at line 8
Same PLSQL block works if the xml size is <15 KB , i have gone through lot of forums and came to know that XMLTYPE loads xml into memory thats why erroring for large xml.
Not able to find soution in any of threads how to handle this scenario i have seen similar threads but none with proper soltuion.
Please help.
Thank you.