How to Disable Edit SQL Popup in PLSQL Code
Laurie Jacobson <[email protected]> Tue, 5 Mar 2013 08:51:09 -0500
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <CAJK8nx4kF4nAqXe3MGJzKvgtqrguvyOy8ptBM0JmXPEEGvyHiQ@mail.gmail.com> |
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!