I have a very peculiar problem. A few days after upgrading from 9.7.2.5 to 10.0 (with 10.1 patch), I started getting prompts for the wrong parameter name. These incorrect prompts happen infrequently, but consistently.
e.g.
--12345678901234567890
SELECT * FROM DUAL
WHERE DUMMY=:DUMMY1;
In this SQL, I get a prompt for :CUSTID (a common column in my database). However, removing or adding a single character on the first line causes the correct :DUMMY1 prompt to be given.
When the incorrect variable name is given, the SQL does not run and no error occurs. The SQL works correctly with the correct variable name.
WORKAROUND:
1. Close Toad.
2. Go to C:\Documents and Settings\dpham1\Application Data\Quest Software\Toad for Oracle\10.0\User Files and rename your variables.dat file.
3. Start up Toad and test the issue
STATUS:
Waiting for fix to be released in a future version of Toad for Oracle.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center