Following error comes up when viewing table data in the Schema Browser:
'ORA-03120: two-task conversion routine: integer overflow'
The data type of a column was once set as DATE, but now has transitioned to TIMESTAMP but Oracle Client cannot interpret it.
RESOLUTION 1:
1. Close Toad.
2. Browse to default folder: C:\Program Files\Quest Software\Toad for Oracle\User Files\
3. Locate your Toad.ini file and rename it to Toad.in.OLD.
4. Re-launch Toad and re-test the issue.
RESOLUTION 2:
Match the Oracle Client version with the Oracle version of the Database Server.
I.E. Oracle 9i Client to a Oracle 9i Database or Oracle 10g Client to a 10g Database, etc.
Download Oracle Clients at the Oracle website:
http://www.oracle.com/technology/software/products/database/index.html
This error message does not occur in SQL*Plus
