XMLTYPE constructor can't parse XML with node over 64K

XMLTYPE constructor can't parse XML with node over 64K. It causes ORA-31167 error.
According to metalink the bug (Bug 4187258 ) should be fixed since 10.1.05 and based release  10.2.

We use 10.2.0.1 release and the problem remains.
We are processing large xml files with such nodes (by 3rd party - we can't influent maximal size of the node)

Any suggestions?

thanks
Bob
LVL 6
JankovskyAsked:
Who is Participating?
 
actonwangConnect With a Mentor Commented:
You could load documentfrom file instead.  There is an existing util package you can use to do it:

http://www.oracle.com/technology/sample_code/tech/xml/xmldb/xdbutilities/XMLDB_Utilities_Overview.html

Acton
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.