title: Oracle Temporary Tables has "data block corrupted"?
body: <p>Within a packaged SP I am populating a Temporary Table. At the end of the procedure processing I read the Temporary Table into a ref cursor.</p>
  
  <p>When I try to execute the procedure in SQL Developer everything works as it should.</p>
  
  <p>When I try to execute the procedure in a Classic ASP page (using OraOLEDB) the IIS logs show "ORA-01578:_ORACLE_data_block_corrupted". </p>
  
  <p>When I first saw this, and before I tried it in SQL Developer, I thought the tablespace file was corrupted so I dropped the tablespace; recreated it on another disk and then told the user that the new tablespace was the new temporary area.</p>
  
  <p>Tried again, same thing only referring to the new tablespace !</p>
  
  <p>I presume that there's something about my use of Temporary Tables which is causing this problem ? </p>
  
  <p>In case it's significant what I'm trying to do here is to reuse an old, complex SP which used to return a number of Table (associative array) objects. I don't want to change too much about the SP so I've got it writing the data that was previously placed into the associative arrays into the temporary table. Then I dump the contents of the TT into the ref-cursor. I can't see how any of that would create the "data block corrupted" message but I hope someone can tell me.</p>