Solved

ORA-31167: XML nodes over 64K in size cannot be inserted

Posted on 2008-10-14
2
1,560 Views
Last Modified: 2013-12-18
hi i am using oracle 10g version(10.2.0.1.0 ).
when i try to read my xml which is huge.. i m thrown with the above exception. is there a fix for this in this release of oracle?
thanks.
0
Comment
Question by:samir25
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 7

Accepted Solution

by:
grzessio earned 250 total points
ID: 22718369
i think that you could read this article:
http://forums.oracle.com/forums/thread.jspa?threadID=280841
0
 
LVL 4

Assisted Solution

by:hqassap
hqassap earned 250 total points
ID: 22747755
Hello,

There is such limitation in 10g regarding XML, read this article to find a workaround for this known issue:
http://forums.oracle.com/forums/thread.jspa?messageID=958230

In 11g, this limitation has been increased to 4GB!

0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

691 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