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.