XML EXTRACT problem in Oracle9i
The following sample program reads a clob from a table and extracts the data section of the XML for later use. The program works fine in 11g but fails in Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production. As you see the size of the original clob is 92754 but it is reduced to 816 first characters of the clob after the XML.EXTRACT.
This code is working fine for small XML (clob) documents in 9i. So the problem should be related to size of the xml in 9i. I have enclosed the original clob in a file.
Thanks for your help.