ORA-31167: 64k size limit for XML node
464105Jan 8 2006 — edited Mar 31 2011Hi,
I have an application that archives XML documents provided by another organization. The other organization, a government regulatory body, controls the format and content of the documents. Many of the documents have large text nodes consisting of hundreds of kilobytes of CSV data.
This application was developed against Oracle 9i and runs fine on that product. Testing against Oracle 10g, I get "ORA-31167: XML nodes over 64K in size cannot be inserted".
As I read it, 64k is a fixed limit in Oracle10g. This limit did not seem to appear in Oracle9i however?
What are my options for upgrading this application to Oracle10g? I can think of:
1) Stay on 9i.
2) Mess around with the XML content. This kind of compromises the purpose of the application, which is to archive the documents unchanged.
3) Store the documents as CLOBs and forego the XML DB features.
4) Abandon Oracle and use another XML database???!
I've been really impressed with Oracle XML DB to date. I find this limitation quite hard to believe. I'm really hoping there is a simple alternative that I'm missing.
Any ideas?
John Hurst
Wellington, New Zealand