Global temporary tables getting data from different session in Oracle
Posted
by Omnipresent
on Stack Overflow
See other posts from Stack Overflow
or by Omnipresent
Published on 2010-05-26T16:09:52Z
Indexed on
2010/05/26
16:11 UTC
Read the original article
Hit count: 230
Oracle
We have a stored procedure in Oracle that uses global temporary tables. 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 delete's.
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?
© Stack Overflow or respective owner
