Merge two xml documents

Posted on 2001-08-02
Last Modified: 2008-02-01
  I have two xml documents stored as OracleXMLDocGenString objects doc1 & doc2, each of them generated through the qry.getXML() method. Now i want to merge the two documents into a third OracleXMLDocGenString Object doc.

I tried the method docAppend in OracleXMLDocGenString
but this appends a null to my document doc instead of the xml.

The doc1.getXMLDocumentString() & doc2.getXMLDocumentString() returns the whole 347 records i have in my xml document and so i am sure the objects doc1 and doc2 are properly created.

Can anyone tell me how i can merge the two documents into one.

Thank you
Question by:sureshabb
  • 3
  • 2
  • 2
  • +1
LVL 27

Expert Comment

ID: 6353740
I suspect that the API definition of docAppend() takes a node list or an XML string and not a "document". I tried to find an API specification for the call on the Oracle site but they restrict passwords to 6-16 characters and Rat's don't like that!

So I would suggest you either try to post the API and/or try something along the lines :-



Author Comment

ID: 6357881
Thank you for the research. The API was defined for the parent class OracleXMLDocGen.
So i had to redefine the doc, doc1 and doc2 as OracleXMLDocGen instead of OracleXMLDocGenString and then populate them with the qry.getXML()
A Method newDocGenDoc helped me create a child node to be appended to the parent doc.

LVL 27

Accepted Solution

BigRat earned 50 total points
ID: 6361153
Oh dear! How complicated.

Well I'm not "au fait" with Oracle APIs but if the documents are not too big I would be tempted to convert them into strings, use a bit of script to put them together with a new <root> and stick the resultant document back into a DOM.

Expert Comment

ID: 6789975
It's time to clean up this topic area and that means taking care of this question. Your options at this point are:

1. Award points to the Expert who provided an answer, or who helped you most. Do this by clicking on the "Accept Comment as Answer" button that lies above and to the right of the appropriate expert's name.

2. PAQ the question because the information might be useful to others, but was not useful to you. To use this option, you must state why the question is no longer useful to you, and the experts need to let me know if they feel that you're being unfair.

3.  Ask Community Support to help split points between participating experts.  Just comment here with details.

4.  Delete the question because it is of no value to you or to anyone else.  To use this option, you must state why the question is no longer useful to you, and the experts need to let me know if they feel that you're being unfair.

If you elect for option 2, 3 or 4, just post comment with details here and I'll take it from there.  We also request that you review any other open questions you might have and update/close them.  Display all your question history from your Member Profile to view details.

---------->  Hi Experts:

In the event that the Asker does not respond, I would very much appreciate your opinions as to which Expert ought to receive points (if any) as a result of this question.  Likewise, you can also suggest that I PAQ or delete the question.

------------->  The ALL TOPICS link has been updated today to reflect all the new TAs.

Thank you everyone.

Moondancer :)
Community Support Moderator @ Experts Exchange
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

LVL 23

Expert Comment

ID: 6946873

delete question

any objection should be raised within 7 days


LVL 23

Expert Comment

ID: 6947311
thank you for finalising this question. As usual, you shd provide explanation for grades other than A.

Expert Comment

ID: 6947889
Thanks for returning and finalizing your questions.  Please let us know where we fell short of expectations, given you've assigned a "B" grade versus "A".  If this was in error, I can correct this.  Your points remains the same, but the expert points that flow are a direct result of the grades assigned.  If you found additional information outside this question thread, and can add it here, that will help others as they access this item looking for solutions in the future.

Moondancer - EE Moderator

Author Comment

ID: 6948373
Sorry the grade should be 'A'

Expert Comment

ID: 6958491
Thank you, this has been corrected.
Moondancer - EE Moderator

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Browsing the questions asked to the Experts of this forum, you will be amazed to see how many times people are headaching about monster regular expressions (regex) to select that specific part of some HTML or XML file they want to extract. The examp…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

747 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

11 Experts available now in Live!

Get 1:1 Help Now