RE: SQL XML Question

  • From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
  • To: <Steve.Booth@xxxxxxxxxxxxxxx>
  • Date: Fri, 22 Sep 2006 22:25:37 +0200

Steve

> Third (doesn't return author, firstname or ISBN)?

Two problems here...

1) the XPath expression '/bookcatalog/book/title/firstname' is wrong.
You should use '/bookcatalog/book/author/firstname'.

2) extractValue cannot be used with an expression like
'/bookcatalog/book/title/author' because it contains sub-nodes.

> Fourth (Returns incorrect value from the existsNode function)?

The XPath expression '/bookcatalog/book/title[QUERY="History of
Interviews"]' should be '/bookcatalog/book/title[text()="History of
Interviews"]'.


HTH
Chris


--
//www.freelists.org/webpage/oracle-l


Other related posts: