i am getting error after running this code
select column list
from tablename
xmltable(
'/Attributes/Map/entry/value/ApprovalSet/ApprovalItem'
passing xmltype(tablename.columnname)
columns
application varchar2(40) path '@application',
operation varchar2(10) path '@operation',
id VARCHAR2(40) path '@id',
state varchar2(10) path '@state'
) clobdata
I have a column which is clob datatype which holds xml data, but some values in that column are empty , so when i run this code after few records got fetched, it is throwing error that:
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00007: unexpected end-of-file encountered
ORA-06512: at "SYS.XMLTYPE", line 272
ORA-06512: at line 1
31011. 00000 - "XML parsing failed"
*Cause: XML parser returned an error while trying to parse the document.
*Action: Check if the document to be parsed is valid.
so, i want to troubleshoot where the data is empty or at what record i am getting error. So any suggestions how to troubleshoot the data. thank you