• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1239
  • Last Modified:

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
0
Jankovsky
Asked:
Jankovsky
1 Solution
 
actonwangCommented:
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now