Questions tagged [qxmlquery]
39 questions
10
votes
2 answers
Oracle XMLQuery inserting unwanted namespace
Oracle 11.2
Below is a cut down version of an XMLQuery i'm running on an XMLType column. When I run the query, which simply parses and recreates the stored XML, the unwanted default and tsip namespaces get inserted into the child elements of the…
DS.
- 604
- 2
- 6
- 24
5
votes
2 answers
Why QXmlQuery seem to add a ` \n` to results? (and how to solve it?)
Writing a little code to extract some values from an XML, the result of the XPath seem to add \n after the content.
#include
#include
#include
#include
auto main(int argn, char* argc[])->int
{
…
Adrian Maire
- 14,354
- 9
- 45
- 85
3
votes
2 answers
Can I use user defined function in Xquery to replace node value in PLSQL?
I want to change oracle xmltype node value by my function my_calculator but I can't.
See there:
set serveroutput on
declare
w_xml xmltype;
begin
SELECT
XMLQUERY('copy $tmp := .
modify
(for $l3 in $tmp//Line3
…
oldnewdb
- 66
- 4
2
votes
0 answers
xmlstarlet: selecting all values based on element and attribute
I'm learning-by-doing xmlstarlet to perform a specific task:
To select every in an element with the parent and additional with the attribute @identifier="MAXSCORE" (and print them line-by-line).
With this…
Jürgen O.
- 23
- 4
2
votes
1 answer
Search for nodes in a QDomDocument using XPath
I am spoiled (rotten, to be sure) by C# and its XML manipulation classes in the System.Xml namespace. I can load an XML file into an XmlDocument. I can search the whole document for nodes that match an XPath expression, using XmlNode.SelectNodes(…
Mike Finch
- 746
- 1
- 7
- 20
1
vote
1 answer
XMLExists Select in DB2 for complex data
I have this xml on my db:
Accept
text/plain, application/json, application/*+json, */*
PUT
…
Ad1Os
- 11
- 2
1
vote
1 answer
Get value by passing dynamic node name of XML
I want get value of node by passing node name dynamically.
I am using this xml:
DECLARE @xml AS XML = '
TestDatabase
Person
ID
sa
…
Tejas
- 107
- 4
- 13
1
vote
2 answers
XMLQuery to INSERT/DELETE XML Elements
I am trying to get a taste of XML manipulation in Oracle PLSQL. All the examples are of modifying XML stored in table column but I am trying to modify a XML variable.
Here is my code -
declare
l_xml XMLTYPE;
l_clob…
redsoxlost
- 1,215
- 5
- 19
- 32
1
vote
0 answers
SSRS XML Query Issue
I have an issue with an XML Query that I have been chewing for a while and I can't get past it. I have:
Created a Shared XML Data Source pointing to an ASMX web service.
Attempted to create a Dataset using XML Query.
a) If I take the web service…
Juan Cabrera
- 11
- 3
1
vote
0 answers
XPath: element with attribute invalidates query
I'm fetching the