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">




      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.