Last updated on FEBRUARY 08, 2017
Applies to:
Oracle Database - Enterprise Edition - Version 11.1.0.7 and laterInformation in this document applies to any platform.
***Checked for relevance on 02-Dec-2013***
Symptoms
After upgrading the database from 10.1.0.3 to 11.1.0.7, a piece of code that functioned fine in 10g now fails in 11g. The file loaded into the XML parser has special characters in it.
Error Message:
ERROR at line 1:
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00283: document encoding is UTF-16-based but default input encoding is not
Error at line 1
ORA-06512: at "XDB.DBMS_XMLPARSER", line 119
ORA-06512: at line 10
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00283: document encoding is UTF-16-based but default input encoding is not
Error at line 1
ORA-06512: at "XDB.DBMS_XMLPARSER", line 119
ORA-06512: at line 10
Below is the first line of the XML file:
\220\221<?xml version="1.0" encoding="utf-16"?>
If "\220\221" is removed from this line, the file processes correctly:
PL/SQL Code being used:
DECLARE
parser xmlParser.parser;
newDomDoc xmlDom.domDocument;
retdoc xmlDom.domDocument;
newElem xmlDom.domElement;
BEGIN
parser := xmlParser.newParser;
xmlparser.parse(parser,'/home/scott/test.xml');
retdoc := xmlParser.getDocument(parser);
newElem:=xmlDom.getDocumentElement(retdoc);
END;
/
parser xmlParser.parser;
newDomDoc xmlDom.domDocument;
retdoc xmlDom.domDocument;
newElem xmlDom.domElement;
BEGIN
parser := xmlParser.newParser;
xmlparser.parse(parser,'/home/scott/test.xml');
retdoc := xmlParser.getDocument(parser);
newElem:=xmlDom.getDocumentElement(retdoc);
END;
/
Cause
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms