XML Parsing Failed LPX-00216 Invalid Character
I am using 19c(19.10.0.0.0) I am running following query and getting XML parsing failed error. Text looks quite simple and apparently there is no reason for this error.
select rtrim (xmlagg (xmlelement (e, (SUBSTR('MR NALIN – ASM 14/08/19 765065873 DIALOG DONGLE-15/07/19',1,25)) || ',')).extract ('//text()').getclobval(), ',')
from dual