xmldom

Generate XML document in PL/SQL from Oracle tables

I have to generate XML documents in PL/SQL from some tables in Oracle. I have never done this before, and I have found there seem to be a few main ways to do it: xmldom API xml functions (such as xmlelement, xmlagg, xmlroot) dbms_xmlgen functions There are 65 tables that will be referenced to generate a single document, and I will ha...

pl/sql: converting xmltype to node

I am trying to put together an XML document from several pieces. To get the data, I had several queries whose results were XMLTypes. I found a function named getNodeFromFragment in the xmldom package that looked like it could take these XMLTypes and return a DOMNode that contained them, but it doesn't seem to work. Simple example here:...

MICROSOFT.XMLDOM -- selecting a node that contains a specific node

Here is an extract from the XML: <?xml version="1.0" encoding="utf-8"?> <usa_map_locator> <map_data> <state> <id>2</id> <link/> </state> <state> <id>3</id> <link/> </state> </map_data> </usa_map_locator> I need to assign a value to the link node for state 2 (or 3 or 4 or 5 and so on)...

Traversing all nodes in an XML file with VBScript

I have written a VBScript which is supposed to tranverse all nodes in an XML file, irrespective of the depth of the tree. This it does well except that the node names for the those nodes which are 2 or more levels deep are not displayed. I need the node names as well as the values so that I have name/value pairs for further processing by...

alternative to ancestor-or-self ( or select all nodes in the tree with a specific child node)

I am trying to identify all the nodes in a tree that lead to a specific node. I am trying to accomplish this through either MSSQL XML (2005) or by the Microsoft.XMLDOM in ASP classic. I know the logic with XPATH but SQL Server does not support the ancestor-or-self axis and XMLDOM seems to choke on the :: notation.. The xpath that work...

How do I parse an XML file that's on a different web server?

I have a list of training dates saved into an XML file, and I have a little javascript file that parses all of the training dates and spits them out into a neatly formatted page. This solution was fine until we decided that we wanted another web-page on another sever to access the same XML file. Since I cannot use JavaScript to parse a...

PHP XML DOM - getElementsByTagName

I'm trying to use the weatherbug API, but seem to be stuck quite early in the proceedings. The [very simple] code I tried: function weather_widget($apikey, $zipcode) { $url = "http://$apikey.api.wxbug.net/getLiveWeatherRSS.aspx?ACode=$apikey&amp;zipcode=$zipcode&amp;unittype=0&amp;outputtype=1"; $contents = file_get_contents($url);...

Xquery to get all nodes that has a particular attribue

I have a XML file that has lot of elements with a particular attribute say href. Is there any x query to get all the nodes that has href = "ABC.jpg" ? If not what is the best way to do it ? ...

To uncomment a commented node in a XML file using C#

I have a XML file which has a node which is commented out. I have created this node using the syntax - relTableCommentedNode = xDoc.CreateNode(XmlNodeType.Comment, "RELTABLECOMMENTED", "np"); What is the best approach to uncomment this node ? Can I identify this node based on the name which I used to create the node (RELTABLECOMMENTED...