title: IBM Worklight - How to get OUT parameter when invoking a stored procedure?
body: <p>I want to know is it possible to get <strong>OUT parameter</strong> when invoking  a stored mysql procedure using <em>worklight SQL adapter</em>.</p>
  
  <p>For example i have an employee table:-</p>
  
  <p><img src="https://i.stack.imgur.com/cRjgA.png" alt="enter image description here"></p>
  
  <p>and stored  procedure for above table is:-</p>
  
  <p><img src="https://i.stack.imgur.com/xh7VB.png" alt="enter image description here"></p>
  
  <p>and then i query like this:-</p>
  
  <p><img src="https://i.stack.imgur.com/DhBsz.png" alt="enter image description here"></p>
  
  <p>It gives the following result :-</p>
  
  <p><img src="https://i.stack.imgur.com/iZaE2.png" alt="enter image description here"></p>
  
  <p>Which is working fine.</p>
  
  <p>But when I invoke same procedure using Worklight SQL adapter instead on query browser 
  like: -</p>
  
  <pre><code>WL.Server.invokeSQLStoredProcedure({
           procedure : "usp_GetEmployeeName",
      parameters : [103,"@name"]
  });
  </code></pre>
  
  <p>it only return me the result set and does not return <strong>OUT</strong> parameter value.</p>