title: temporary table does not exist in mysql stored procedure
body: <p>i written a two Stored procedures in <code>Mysql</code></p>
  
  <pre><code>1.business logic(SP1),
  2.dynamic temporary table creation(SP2)
  
  in Sp2 am creating temp table
  in sp1 am inserting values.. 
   am calling SP2 in SP1.. 
  </code></pre>
  
  <p>if i call <code>SP1</code> from console application its working fine but..</p>
  
  <p>if i calling <code>same stored procedure SP1</code> in <code>web application</code> its throwing an <code>Exception</code> like <code>temporary table not exist</code>..</p>
  
  <pre><code>why its happen like this ???
  any suggestions ?? tell me the reason..
  </code></pre>
  
  <p>thanks in advance.. </p>