xmlquery | xmlquery is Golang XPath package for XML query | Parser library

You can use XMLTABLE:

Here is an example of how you can do it with reflect. Only changed the value inside XmlVerify to make the example a bit easier. Also make sure the method names are exported (capitalize).

1. You haven't specified namespace, but your xml contains it, so oracle tried to find wrong elements. To search in all namespaces you can use *: as a namespace;
2. If you want to delete whole node Receipt you should specify exactly Receipt and put all other filters into [], so, in short, we can put filter by child nodes into the filter. for example: $NEWXML//*:Receipt[./*:ReceiptDtl/*:unit_qty/text() eq $NAME] means that we want to delete all Receipt which contains at least one child node ReceiptDtl/unit_qty with a value = $NAME;

Try this:

You can use angular service to implement getJobstatusdata() method. Then pass the instance of the new service in constructor of TraceLogpageComponent or JobStatusComponent as you like. You should be able to fetch setTableData without actually calling the api again and again or pass boolean parameter to getJobstatusdata() when you need to refresh table data.

In Microsoft SQL Server you can use XQuery via the nodes(), query() and value() functions.

If the source data involves custom XML namespaces you can also use with xmlnamespaces to namespace qualify the nodes of your XQuery, for example:

You need to declare a default namespace right in the XMLQUERY.

SQL16085N, QName = err:XUTY0008

err:XUTY0008

The value of expression-type is "replace" or "replace value of" and the target node of a replace expression does not qualify any node, qualifies a sequence of two or more nodes, or qualifies a document node. It must qualify exactly one node that is not a document node.

You must iterate through the nodes, if you have multiple ones in a document.
Use the following instead:

Use getclobval() like this: