If a query with substitution variables has comments in between the queries, the Editor will not prompt users for substitution variables even if View | TOAD Options | Execute/Compile | Prompt for substitution variables is CHECKED.
Possibly, the formatter in TOAD 9.0.1.8 doesn't recognize comments in a code when executing a query as a statement (F9.)
WORKAROUND:
Remove the comments from your query or Use F5 (execute as script) to run your query.
STATUS:
Issue fixed in version 9.1.0.55. The latest version of Toad for Oracle can be downloaded here.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy