SQL Language (MOSC)

MOSC Banner

XML Parsing Failed LPX-00216 Invalid Character

in SQL Language (MOSC) 4 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center