XMLType and Curled Double Quotes (8220, 8221)
9909Dec 29 2004 — edited Dec 29 2004The following select fails with an XML parser error:
select xmltype('<tag>“A”</tag>') from dual
I'm trying to definitively determine why...
We have XML that goes into a CLOB column in our 9.2 database, then is put into an XMLTYPE variable (in PL/SQL) and manipulated as XML. (The above select statement is just a highly-simplified test case, but we do use XMLTYPE in this manner in our select to convert the CLOB to an XMLTYPE instance.) The data has occasional instances of curled double quotes, represented as “ and ” and when these exist, the XML parse error occurs.
My impression is that these Unicode representations of the curled double quote characters are acceptable in XML. They parse and validate fine in XMLSpy for whatever that's worth. Also, I can construct a DOM document in Java, using Oracle's XMLParser V2, that contains these Unicode representations.
Why can't I do this using XMLTYPE in PL/SQL?
Thanks for any assistance!
Jim