title: Local Temporary table in Oracle 10 (for the scope of Stored Procedure)
body: <p>I am new to oracle. I need to process large amount of data in stored proc. I am considering using Temporary tables. I am using connection pooling and the application is multi-threaded. </p>
  
  <p>Is there a way to create temporary tables in a way that different table instances are created for every call to the stored procedure, so that data from multiple stored procedure calls does not mix up?</p>