I have often loaded data from Excel to a global temporary table in Toad for Oracle and been able to see/query the data both in Schema Browser and Editor.
With version 184.108.40.206 w/ DB Admin Module, I am now unable to query the data after loading via Schema Browser or when using the EXECUTE button in Editor. When I use Editor and execute my code via the “Run as a Script” button, the data is visible.
The GTT has PRESERVE on commit, hasn’t been modified in years, and I’ve used it as described above flawlessly for years.
Oracle Database 11g Enterprise Edition Release 220.127.116.11.0 - 64bit Production