title: callablestatement.execute() returns an empty resultset if MS SQL preocedure contains CREATE TABLE statement
body: <p>I use Callablestatement class <code>execute()</code> method to call MS SQL procedure.</p>
  
  <p>I call  MS SQL procedure which contains the following statement:</p>
  
  <pre><code>CREATE TABLE #PrevOver (ClCode char(6) NULL , 
  ContrNum char(4) NULL , 
  OverContr smallint NULL, 
  GenerNum tinyint NULL )
  </code></pre>
  
  <p>Table is used as a temporary data storage</p>
  
  <p>If I drop the statement above and re-write procedure that way that it returns data with select statement only - everything works fine. The problem is that some procedures require "CREATE TABLE" statement.</p>
  
  <p>I connect with "sa" permits, so it shouldn't be permission problem.
  I use jtds</p>
  
  <p>Thanks in advance.</p>