Home » SQL & PL/SQL » SQL & PL/SQL » XML over 64K
XML over 64K [message #681472] Tue, 21 July 2020 08:39 Go to next message
Messages: 11
Registered: June 2020
Junior Member
I work on Oracle 10g
I have to load a big XML into an XMLTYPE column so as to extract easily the content of some TAGs.
The problem is that during the load of the XML I get

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

and I've read that on Oracle 10g it's non possible to load more than 64K for an XML. This would be terrible for me, because I suppose I should to load the big XML into a CLOB column but after how could I find the TAGs I'm interested to?
Moreover some TAG are repetead and I know the name of the TAG and its TAG-father and everything would be very simple if I could use XML functions.
Have you got some advice? Has someone developed any function for extract the part of the CLOB contained between <start> and </start> that would be the two TAGs containg what I have to use and so to convert it into a smaller XMLTYPE?

Thanks in advance!
Re: XML over 64K [message #681473 is a reply to message #681472] Tue, 21 July 2020 09:57 Go to previous message
Michel Cadot
Messages: 67363
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Michel Cadot wrote on Mon, 22 June 2020 16:53

Michel Cadot wrote on Wed, 10 June 2020 12:25

From your previous topic:

Michel Cadot wrote on Thu, 04 June 2020 16:42

With any SQL or PL/SQL question, please, Post a working Test case: create table (including all constraints) and insert statements along with the result you want with these data then we will be able work with your table and data. Explain with words and sentences the rules that lead to this result.

And as asked in your previous topic:

Michel Cadot wrote on Wed, 03 June 2020 17:58
Note: Always post your Oracle version, with 4 decimals (query v$version), as often solution depends on it.

A feedback in this topic would also be welcome.

And the other one too.

And the other oneS too, now.

[Updated on: Tue, 21 July 2020 10:00]

Report message to a moderator

Previous Topic: ear multivalue json as rows
Next Topic: ORA-00932: inconsistent datatypes: expected - got NCLOB
Goto Forum:

Current Time: Mon Sep 21 02:37:32 CDT 2020