Return
-
Title
Editor does not prompt for substitution variables in queries containing comments. -
Description
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.
-
Cause
Possibly, the formatter in TOAD 9.0.1.8 doesn't recognize comments in a code when executing a query as a statement (F9.)
-
Resolution
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.