Unable to spool highlighted statement using F5 a single spool file (4279840)

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.