RE: How to Disable Edit SQL Popup in PLSQL Code

Just in case someone asks how to gather the stats - here's  the two commands a DBA user needs to execute

exec dbms_stats.gather_dictionary_stats;
exec dbms_stats.gather_fixed_objects_stats;

But again the toad advisor would help you to turn off options for features that you may not desire  - so don't discount looking there ....

Bert

From: [email protected] [mailto:[email protected]] On Behalf Of Michael Staszewski
Sent: Tuesday, March 05, 2013 8:50 AM
To: [email protected]
Subject: RE: [toad] How to Disable Edit SQL Popup in PLSQL Code


If you can send an example to me offline that might help. Also, have your DB stats been analyzed recently? Toad needs to parse the statement (quick) and resolve identifiers it locates within. This uses a combination of parsing/querying so be sure that your stats are up to date so the queries are as quick as possible. If you're unable to send an example, spool your SQL and reproduce and send me the spooled SQL output. There may be a query in there that can be tuned as well.

Michael

From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Laurie Jacobson
Sent: Tuesday, March 05, 2013 8:51 AM
To: [email protected]<mailto:[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!