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 184.108.40.206. See solution #17322 for downloading instructions.
Note: Version 220.127.116.11 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