RE: How to Disable Edit SQL Popup in PLSQL Code

Remember the toad advisor (main menu -> help -> toad advisor). This screen will show you which things might be slowing down toad and double clicking on them takes you right to options spot to change it

From: [email protected] [mailto:[email protected]] On Behalf Of Laurie Jacobson
Sent: Tuesday, March 05, 2013 7:51 AM
To: [email protected]
Subject: [toad] How to Disable Edit SQL Popup in PLSQL Code


I recently upgraded to TOAD 11.5.1.2

Prior to this I often troubleshoot pl/sql packages by pulling up the code, making a quick mod to the code to add bind variables if necessary, or hard-code some values, etc. so it can run as sql, hit Shift-F9 and away I go!   Super fast.

Now I do the same thing and it takes 8-10 minutes and finally a window pops up saying "Edit SQL" and then I can hit OK to have it bring up the variables window.

I would like to disable this new feature so I can go back to working quickly.

I saw someone else online ask about this and I understand it is related to the fact that the code is within the PL/SQL code and TOAD is trying to be "helpful" by analyzing the pl/sql to figure out what are the bind variables, etc.   But it's extremely painful.

Other than going back to an older version of TOAD .. any thing I can do?    Or other than copy/paste to another window to execute as SQL which just makes it harder to follow the stream of code, particularly if it's not originally mine.

Thanks!