Home » Developer & Programmer » JDeveloper, Java & XML » Improve the performance of XMLConcat (10g)
Improve the performance of XMLConcat [message #486943] Tue, 21 December 2010 06:45 Go to next message
Messages: 1
Registered: December 2010
Location: 25
Junior Member
I'm looking the best way to manage multiple XMLTYPE concatenate.
An option is put the values on a temp table like this:

PROCEDURE enqueue_xml (v_xml IN OUT nocopy XMLTYPE)
insert into T_GENERIC_XML VALUES (v_xml);

PROCEDURE get_queue_xml (v_xml OUT NOCOPY XMLTYPE)
select xmlagg(xml) into v_xml

Anybody knows a better method to avoid the XMLCONCAT function?

Re: Improve the performance of XMLConcat [message #486947 is a reply to message #486943] Tue, 21 December 2010 06:57 Go to previous message
Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is not clear what you have and what you want, and from you call the procedures and in order to do what and so on.

Post a working Test case: create table and insert statements along with the result you want with these data then we will work with your table and data.

Before, Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version with 4 decimals.

Previous Topic: Extract data from XML
Next Topic: Storing XML File In Server
Goto Forum:

Current Time: Sun Jun 23 15:58:29 CDT 2024