Error received when executing a query in Toad:
"OCI-22061: Invalid Format Text (TM9)"
SQLPLUS works without any problems.
1. Select View | Options | Data Grids - Data
2. Verify that the Display Large Numbers in Scientific Notation option is checked.
1. Upgrade to Toad for Oracle 126.96.36.199. See solution #17322 for downloading instructions.
Note: Version 188.8.131.52 supports Oracle clients 8.1.7 and up. Upgrading Oracle clients is suggested if the machines client is before 8.1.7. Here is a link where a 9i client can be downloaded for free. http://www.oracle.com/technology/software/products/oracle9i/index.html