title: Unexpected procedure invocation response
body: <p>I am using IBM Worklight v6.2.  </p>
  
  <p>I want to invoke a procedure on a click of a button to return details from a sql database.</p>
  
  <p>HTML</p>
  
  <pre><code>&lt;div id ="page"&gt;
      &lt;h1&gt; Hi Welcome User&lt;/h1&gt;
      &lt;input type="submit"  id="user" onclick="loadFeeds()" value="Submit"&gt;
      &lt;span id="result"&gt;&lt;/span&gt;
  &lt;/div&gt;
  </code></pre>
  
  <p>JavaScript</p>
  
  <pre><code> function loadFeeds(){
       var invocationData = {
           adapter:"car1",
           procedure:"getuser",
           parameters:["name","city"]
       };
  
       WL.Client.invokeProcedure(invocationData,{
           onSuccess :loadFeedsSuccess,
           onFailure :loadFeedsFailure,
       });
  }
  
  function loadFeedsSuccess(result) {
      var xyz=result.invocationResult.resultSet[0];
      $("#result").html(xyz.name+" "+xyz.city);
      //$("#result").html(xyz.city);
      //alert(xyz.name);
  }
  
  function loadFeedsFailure(result) {
      WL.Logger.debug("failure"); 
  }
  </code></pre>
  
  <p>Adapter JS</p>
  
  <pre><code>var user = WL.Server.createSQLStatement("select name,city from user");
  
  function getuser(){
      return WL.Server.invokeSQLStatement({
          preparedStatement : user,
          parameters : []
      });
  }
  </code></pre>
  
  <p>I want to invoke all the values from the database but am not able to do that</p>