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
rmoralez
Messages: 1
Registered: December 2010
Location: 25
Junior Member
Hi,
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)
IS
begin
insert into T_GENERIC_XML VALUES (v_xml);
END;

PROCEDURE get_queue_xml (v_xml OUT NOCOPY XMLTYPE)
IS
begin
select xmlagg(xml) into v_xml
from T_GENERIC_XML;
END;

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: 68625
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.

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


Current Time: Thu Mar 28 17:11:02 CDT 2024