When users uses a colon string in query as show in below example, Toad shows the Bind Variable window prompting user to input a value:
select : from dual;
With Prompt for Substitution Variables option turned off, the following error occurs:
ORA-01036: illegal variable name/number
Issue not reproduced in Toad 9.7/
You need to be signed in and under a current maintenance contract to view premium knowledge articles.