Is there a setting to have the executed SQL statement or script be included in the Output window when using F5 or "Execute as Script"? In Toad 8.0.0, this worked fine.
Example:
Execute the statement SELECT * FROM DUAL using F5 or "Execute as Script"
Results in the Output window shows:
SQL> SELECT * FROM DUAL -----> the executed SQL statement or script is included
D
-
X
1 row selected.
WORKAROUND 1:
Add the SET ECHO ON; command above your SQL Statement or script
EXAMPLE:
SET ECHO ON;
SELECT * FROM DUAL;
WORKAROUND 2:
Add a login script to Toad (only the Toad application is affected by this change)
1. Go to your Toad for Oracle folder where the Toad.exe is located i.e. [C:\Program Files\Quest Software\Toad for Oracle]
2. Right-Click in that folder | "New" | choose "Text Document" | and name that file as "LogIn.sql"
3. Open that new "LogIn.sql" file in Notepad
4. Type SET ECHO ON; | save it | and then close it
5. Start Toad | go to View | Toad Options | Execute/Compile | under "Login Scripts" section | checkmark "Execute login scripts"
6. In the same section | click on the "Edit" button for "LogIn.sql" | confirm that it opens the "login.sql" file | and make sure you see SET ECHO ON; in it
7. Exit and restart Toad
8. Re-test the issue
WORKAROUND 3:
Add SET ECHO ON; to the "glogin.sql" file
NOTE: This will affect all applications in your computer that uses SQLNet to connect to Oracle databases
1. Start Toad | go to View | Toad Options | Execute/Compile | under "Login Scripts" section | click on the "Edit" button for "glogin.sql"
2. It will open the "glogin.sql" file
3. In the very end of the contents of the "glogin.sql" file | type SET ECHO ON;
4. Exit and restart Toad
5. Re-test the issue
STATUS:
Enhancement request ST57186 has been submitted to Development for consideration in a future release of Toad for Oracle.
