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/
WORKAROUND:
Add an empty string to the query:
select :|| from dual;
STATUS:
Waiting for fix to be released in a future version of Toad for Oracle.
This issue is fixed in Toad 10.5 Beta. The installer of this version can be obtained at: http://www.toadfororacle.com/beta.jspa
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center