-
Title
OCI-22061: invalid format text [TM9] -
Description
After upgrading to Toad for Data Analysts (TDA) 3.0, the following error is thrown when connecting to an Oracle database which used to work prior to upgrade:
Oracle Database Error
OCI-22061: invalid format text [TM9] -
Cause
A pre-8i Oracle client (e.g. Oracle 8.0.x or 7.x) is installed and included in the PATH environment variable
-
Resolution
WORKAROUND 1
- Close all TDA
- Right-click on My Computer | Properties | Advanced | Environment Variables | System variables | Edit the PATH variable.
- Remove the location reference to the pre-8i Oracle client and only leaving the 8i or later location.
- Click OK three times.
- Launch TDA and connect.
WORKAROUND 2
If removing the pre-8i Oracle client from PATH variable is not acceptable, create a Windows batch script that will launch TDA with its own PATH instance. The batch file should contain the following lines. Ensure that only an Oracle 8i or later is included and remove any pre-8i references.
set PATH=c:\apps\ora920\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\system32\nls;C:\WINDOWS\system32\nls\ENGLISH
"C:\Program Files\Quest Software\Toad for Data Analysts 3.0\toad.exe"Save the batch file (e.g. TDA.bat). Launch TDA by double-clicking the TDA.bat you have created.