Xmlparsing is different in 11g from 10g (文档 ID 1515401.1)

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.

While reading content from xml using xmlparser / xmldom which has been working fine in Oracle 10.2.0.4,once upgraded to Oracle 11.2.0.1,using the same code and xml file,it will return incorrect content from xml.

Example: For example parsing an xml file we observed that some lines are trimmed to the next line like below:

10g output: field_desc = [BEGIN]This is a sample text which gets trimmed/truncated to next line.This is a sample text which gets trimmed/truncated to next line.[END]

11g output: field_desc = [BEGIN]This is a sample text which gets trimmed/truncated to next line.This

is a sample text which gets trimmed/truncated to next line.[END]

Upgrade from 10g to 11gR2.

In 10g the xquery engine is Java based whereas in 11g,the xquery engine is C based XVM.

We can revert to using 10g parser by setting the below event:

alter system set event ="31156 trace name context forever,level 0x400" scope=spfile;

Note:The instance must be restarted for the events to take effect. This is necessary because we are specifying "scope=spfile".