Toad World® Forums

BUG: Bad Bind variable when exporting table data Toad v12.12.0.39

Actions:
Open Schema Browser, select tables, right click on table name, select Data -> Export
result: Parameter XXXXX not found
image
8<-------------------------------------------------------
EurekaLog 7.5.1.0

Application:

1.1 Start Date : Wed, 11 Sep 2019 12:25:41 +1000
1.2 Name/Description: Toad.exe - (Toad® for Oracle)
1.3 Version Number : 12.12.0.39
1.4 Parameters :
1.6 Up Time : 48 minute(s), 8 second(s)

Exception:

2.1 Date : Wed, 11 Sep 2019 13:13:49 +1000
2.2 Address : 000000000495B5E7
2.3 Module Name: Toad.exe - (Toad® for Oracle)
2.5 Type : EDatabaseError
2.6 Message : Parameter 'DOC_DATE' not found.
2.7 ID : 02100000
2.8 Count : 1
2.11 Sent : 0

User:

3.2 Name: [REDACTED]

Active Controls:

4.1 Form Class : TfrmMain
4.2 Form Text : Toad for Oracle - [REDACTED]
4.3 Control Class: TVirtualStringTree
4.4 Control Text :

Computer:

[REDACTED]

Operating System:

6.1 Type : Microsoft Windows 10 (64 bit)
[REDACTED]

Steps to reproduce:

8.1 Text:
8<-------------------------------------------------------

There is no query involved.
This behaviour is repeatable for any table in any database I connect to.

The actual bind variable is used with a query that was run some days ago.

Is there a quick fix for this? I really do not wish to have to reinstall toad and all of my custom settings.

I’m on the road now so I’m not 100% sure but I think if you rename the variables.dat file (in user files folder) the problem will disappear. The bug was fixed in either 13.0 or 13.1. Be sure that Toad is not running when you rename the file.

I can let you know for sure tomorrow but hopefully this will get you going again.

Renaming the variables.dat did not work.
Any other suggestions?

Try renaming both Variables.dat and ToadActions.dat (at the same time).

If that doesn't solve it, this will, but it will restore Toad to a "like new" state, and you'll lose all of your settings.

  1. Open Copy User Settings from the Utilities menu
  2. Choose the option to Reset to a clean set
  3. Click OK
  4. Choose Yes and then OK on the next two dialogs

This will restore Toad to a clean state as if it were freshly installed. Your existing user files will be backed up to %APPDATA%\Quest Software\Toad for Oracle\12.12_bak .

If you want to get some settings back, you can copy these from the User Files under the _bak folder to the new one.

Connections.XML (saved connections in login window)
SavedSQL.XML (SQL Recall)
Workspaces.dat (saved Workspaces)
*.tpr (Project Manager projects)

If there is something else you want to pull back over and don't know where it is, let us know.

Thank You - the renaming combination of Variables.dat and ToadActions.dat worked!