title: Global temporary tables getting data from different session in Oracle
body: <p>We have a stored procedure in Oracle that uses <code>global temporary tables</code>.  In most of our other stored procedures, first thing we do is delete data from global temporary tables.  However, in few of the stored procedures we do not have the <code>delete's</code>.  </p>
  
  <p>Are there any other options other than adding the delete statements?  Can something be done on the Server side to forcefully delete data from those temporary tables when that SP is ran?</p>
  
  <p>the GTT's are defined with <code>ON COMMIT PRESERVE ROWS;</code></p>