Error on Global temporary table
693780Jul 13 2009 — edited Jul 13 2009Hi,
I am creating one stored procedure and creating one global temporary table for a session in the code.
I checked in code, if temp table is already created then first trucate it and then drop it and recreate it again. because temp table is dynamic.
When I execute it in oracle it is working fine but when I called it in Application. it shows an error i.e. temp table is already in use.
I am a bit confused, How can this error comes even when I trucate it before drop that table.
temp table keep the data session wise. when I truncate it then will it trucate the data from all session?
Prashant...