3 Replies Latest reply: Feb 28, 2011 10:05 AM by Kellie Koch RSS

SQL query against  web service vdb

Kellie Koch Newbie

I am running a select query against a VDB for a web service (ie   select xmlserialize(document w.result as string) .......)

The query is returning the result below.

 

  <ns1:processResponse xmlns:ns1="http://com.test.ws/exampleWebService">

    <return>Hello</return>

   </ns1:processResponse>

 

I am now trying to change the select statement to return just the response value of "Hello".  I tried xmlpathvalue('ns1:processResponse/return') and get an error,  xmlpathvalue('processResponse/return') and get null.  I played with variations of xmlquery trying to declare the namespace, but just cannot get the right syntax. 

 

Can somebody help me out.