Re: Solution for Migrating @Tbl Table Variables
Posted by:
Paul Lopez
Date: April 17, 2007 04:24AM
I'm also looking for a solution to this. In MS Sql the table variable is held in its own thread so that if a stored procedure is call twice by 2 different apps or uses it will not write over or append to the same table. From what I can gather from the documentation is that once the table is created is it always there but the data is stored in memory. Which I guess would be ok if that data is only handled by the individual thread.
Is this how it works or are temp tables global no matter if created in memory?
Subject
Written By
Posted
February 14, 2007 01:29PM
February 14, 2007 04:24PM
Re: Solution for Migrating @Tbl Table Variables
April 17, 2007 04:24AM
September 08, 2008 01:05PM
September 08, 2008 01:58PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.