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

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Oracle SQL Syntax 8 57
Pl/SQL Query 31 62
PL/SQL Search for multiple strings 5 22
case statement in where clause with not exist 15 33
Article by: Swadhin
From the Oracle SQL Reference ( we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

758 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

20 Experts available now in Live!

Get 1:1 Help Now