ORA-19202: Error occurred in XML processing
I have following 2 tables.
a)
SQL> desc purchaseorders
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NOT NULL NUMBER
XMLPO XMLTYPE
b)
SQL> desc purorder
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NUMBER
CC CLOB
c) The sample data in purorder table is as follows:
SQL> set long 60
SQL>
SQL> select * from purorder;
ID CC
---------- ------------------------------------------------------------
1 <?xml version="1.0" encoding="ISO-8859-1"?><BetradarBetData>
d) I am getting following error:
SQL> insert into purchaseorders select id, xmltype.createxml(cc) from purorder;
insert into purchaseorders select id, xmltype.createxml(cc) from purorder
*
ERROR at line 1:
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing