PL/SQL (MOSC)

MOSC Banner

XML EXTRACT problem in Oracle9i

edited May 11, 2012 1:11AM in PL/SQL (MOSC) 3 commentsAnswered
Hi All,

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.

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