I have a very peculiar problem. A few days after upgrading from 188.8.131.52 to 10.0 (with 10.1 patch), I started getting prompts for the wrong parameter name. These incorrect prompts happen infrequently, but consistently.
SELECT * FROM DUAL
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.
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
Waiting for fix to be released in a future version of Toad for Oracle.