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!