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

Posted on 2008-10-14
Last Modified: 2013-12-18
hi i am using oracle 10g version( ).
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?
Question by:samir25
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

Accepted Solution

grzessio earned 250 total points
ID: 22718369
i think that you could read this article:

Assisted Solution

hqassap earned 250 total points
ID: 22747755

There is such limitation in 10g regarding XML, read this article to find a workaround for this known issue:

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


Featured Post

Independent Software Vendors: 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

Suggested Solutions

Title # Comments Views Activity
SQL Developer 6 75
constraint check 2 57
oracle numeric condition check 4 37
Oracle programming for starter 14 35
This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

726 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