title: life span of temp table
body: <p>I have the following procedure:</p>
  
  <pre><code>CREATE PROCEDURE foo ()
      SELECT * FROM fooBar INTO TEMP tempTable;
  
      -- do something with tempTable here
  
      DROP TABLE tempTable;
  END PROCEDURE;
  </code></pre>
  
  <p>What happens if there is an exception before the DROP TABLE is called? Will tempTable still be around after foo exits?</p>
  
  <p>If so, foo could fail the next time it is called, because tempTable would already exist. How should that be handled.</p>
  
  <p><strong>EDIT: I am using informix 11.5</strong></p>