Toad
User creates a procedure to populate a Global Temporary Table but can not view the data.
When executing a procedure in the Procedure Editor window it creates three sessions because of the debugger. Since the Global Temporary table data will only be preserved for the active session, the data will be stored in the initial session but will be deleted when the new sessions are established. To work around this, in the Schema Browser/Procs Tab, right-click the Procedure and select Execute Procedure. This establishes only one session as the debugger is not initiated and the data becomes viewable.
