When there are multiple queries in the Editor, highlighting anyone and running it with F5 will only run that query; however, each of the highlight query is ran in its own session. This creates a problem with the SPOOL command.
If starting a spool to a file by highlighting the command and running it with F5, Toad runs it as one session but any other highlight query in the same editor will not get spooled as they are each will run in different sessions.
For example, given the following queries all in on Editor:
SPOOL C:\spoolout.txt;
select '1st F5' from dual;
select '2nd F5' from dual;
select '3nd F5' from dual;
spool off;
When highlighting the SPOOL statement and running it with F5, one session is created then closed. When Highlighting 2nd F5 query and running it with F5, another session is created and then closed. Hence, nothing is spooled out as a result.
1.
WORKAROUND: Run each query that needs to be spooled to file in its own Editor.
STATUS: Enhancement request has been submitted to Development for consideration in a future release of Toad for Oracle on the Toad Idea Pond.
The Toad Idea Pond was launched with the intention of allowing our customers participate in the decision-making process. You can submit your ideas for new features, vote on your favorite ideas submitted by other Toad users, and track enhancement requests through implementation into Toad.
Please visit the following site for this enhancement:
