This is for version 17.0.341
I notice this odd behavior in the spool running the query
Why is Toad changing the current_schema before running the query and then changing it back?
Assuming you are running the Select count(*)...from the Editor, then you probably have the "Current Schema" dropdown (in the Editor's toolbar) set to something other than your login user name.
In the screen shot below, I am logged in as JDORLON. Current schema in the Editor is set to SCOTT. You can see in the spool SQL output that when I run the query with F9, current schema is changed, then we run the query that's typed into the Editor, then we restore the current schema.
1 Like
You are right, somehow the current schema dropdown was selected to the other schema. Strange because I never use that and the session was freshly loaded from a saved workspace. Is there a way to view what's saved in the workspace?
Hi Raymond,
Sorry, there is no way to peek into a workspace to see its contents. You just have to load it to see.
Current Schema is saved in the workspace, so my guess is that you inadvertently changed it. You can just change it back and then re-save the workspace.
-John