When trying to export a dataset in the Data Grid, I get the following error:
The parameter is incorrect
It doesn't matter what format the export is set to, Excel, Excel Instance, Delimited Text, etc., the same error occurs. Query involved did use paramter settings.
WORKAROUND:
Reset the User Files settings.
In Toad for Oracle 11.5 or higher:
1. In Toad, go to Session | New Connection and export your connections.
2. Close the Connection Window and go to Utilities | Copy User Settings.
3. Select, ‘Create a clean set of user files from the base installation’ and click OK, then OK to restart Toad.
4. When Toad starts, check the ‘Save Passwords’ box (only if you had saved passwords checked last time) and then import your connections.
5. Connect and re-test the issue.
In Toad for Oracle 11.0 or lower:
1. Close Toad.
2. Browse to default folder:
Windows XP - C:\Documents and Settings\<User_Name>\Application Data\Quest Software\Toad for Oracle.
Windows Vista\7 - C:\Users\<User_Name>\AppData\Roaming\Quest Software\Toad for Oracle
3. Locate the 11.0 folder and rename it to ’11.0_OLD’. (Or the appropriate version folder name)
4. Re-launch Toad for Oracle.
5. Re-enter your Toad license key and during initial setup, select the option “Do not copy my user files. Perform a clean install.” And click next.
6. Continue with the initial setup and re-test the issue.
If it works, to pull over some connection history files and passwords:
1. Close Toad again.
2. Browse to the ’11.0_OLD’ folder (or appropriate version folder) that was backed up previously.
3. Open the User Files folder and locate the following files:
* CONNECTIONACTIONS.INI (If it exists)
* CONNECTIONPWDS.INI
* CONNECTIONS.INI
* SavedSQL.dat
4. Paste those files in the new ’11.0\User Files’ directory and replace the existing ones there.
5. Launch Toad again and the connections and passwords will be restored.
