Hello Everyone,
In my table abc, i have XML data (CLOB data type) in column perls.
When I use select statement to retrieve data, it work very fine but when the clob data contain null value, it display error as
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00229: input source is empty
How to resolve it . Please help me.
SELECT XMLTYPE (a.perls).EXTRACT ( '//fax/text()').getStringVal () from abc a