title: How to return in out parameter from procedure using groovy
body: <p>I follow this example to call and return parameter from procedure using groovy: <a href="http://groovy.codehaus.org/Database+features" rel="nofollow">http://groovy.codehaus.org/Database+features</a></p>
  
  <p>in section Stored procedure support there no example how to call in out procedure
  I try this but output is still null</p>
  
  <pre><code>sql.call(GString.EMPTY +  "{call " + schema + "." + name + "($par1,$par2)}"){ output -&gt;  println output }
  </code></pre>
  
  <p>UPDATE:</p>
  
  <p>in my case if par1 == null then it take new entry (this is reason of "in our parameter" ) so I created something like this:</p>
  
  <pre><code>    if (par1 == null) {
          sql.call(GString.EMPTY +  "{call " + schema + "." + name + "(${Sql.VARCHAR},$par2)}"){  output_par1 -&gt; println "par1: " + output_par1  }
      } else {
          sql.call(GString.EMPTY +  "{call " + schema + "." + name + "($par1,$par2)}"){}
          println "par1: " + par1
      }
  </code></pre>
  
  <p>so If par1 is null procedure generates new value and then is println and if par1 is not null then just println it. This works for me but if someone want to return in out parameter which is not null then I still dont know how to write it.</p>
  
  <p>UPDATE</p>
  
  <p>really nothing ? after 7 days with bounty ? I should probably add more point</p>