Having problems when using Toad with TFS and using ampersand in the code (&).
For example for the procedure below the ampersand variable doesn't represent a substitution variables but Toad aks for the value when working with TFS (checking in/out/get latest version).
CREATE OR REPLACE PROCEDURE test_sub_variables IS
v_var varchar2(120):='';
BEGIN
v_var :=' ';
END;
/
Note that in View|Toad Options|Execute/Compile the option “Substitution Variable Prompting” is set to “None” but Toads ignores this when working along TFS.
WORKAROUND
None
STATUS
Issue fixed in version 14. The latest version of Toad for Oracle can be downloaded here .
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center