Toad for Oracle - version 188.8.131.52
I have a package stored proc that INSERT’s into a global temporary table - I’d like to execute that stored proc, and then be able to query the temp table myself with some adhoc queries, but I can’t seem to find a way to do that in Toad. I can execute the stored proc and that works fine, and the cursor it opens at the end looks fine. But after it executes, when I try to query the temp table that is populated by the stored proc, the temp table contains no rows. It there any way to execute/debug the stored proc such that I can query the temp table afterwards?
Thanks for any info.