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

Posted on 2006-06-08
Last Modified: 2008-01-09
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 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?

Question by:Jankovsky
    1 Comment
    LVL 19

    Accepted Solution

    You could load documentfrom file instead.  There is an existing util package you can use to do it:


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
    Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
    Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
    Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

    794 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now