How to set context in Schema Browser so it will show in Session Browser, SYS.AUD$, etc.?
For example, need to use the script below in SQL Editor:
"exec dbms_session.set_identifier('Fixing data with Schema Browser for project x');"
1) Go to View menu | Toad Options | Oracle | Transactions | make sure that the "Execute queries in threads…" option is Un-Checked.
NOTE: Un-checking this option will disable the Toad capability to run statements simultaneously i.e. running queries in multiple Editor windows at the same time. The Stop or Halt button will also not function.
2) Next, ensure the "Execute scripts in Toad session" option is Checked.
3) Next, run the “exec dbms_session.set_identifier..." statement in the Editor, and it should now work.
