ORA-3120 querying across a DB-Link from a 9i2 db to and 8.1.7 db using an 8.0.6 Client SQLPlus

We get ORA-03120 errors when using Windows SQLPlus 8.0.6 connecting to a 9.2.0.1 Database and querying across a DB-Link to an 8.1.7 database.

Server Database : 9.2.0.1 on Solaris 2.8 Client SQLPlus : 8.0.6 on Windows
Target DB which DB-Link connects to : 8.1.7.2 on Tru64

A Public Database link in the 9.2.0.1 database on Solaris has been created to
  connect to the 8.1.7.2 Database on Tru64. When running the query   "SELECT * FROM TAB_at_R11TEST_LINK" using a 9.2.0.1 SQLPlus [ie on the server],
  there are no errors. If the client connects from a Windows PC running SQLPlus
  8.0.6 to the 9.2.0.1 database and then queries across the link, with the same
  query "SELECT * FROM TAB_at_R11TEST_LINK" we get the ORA-03120 error. If we SET
  ARRAYSIZE=1, we get one record before the error. If we SET ARRAYSIZE=100, we
  get the error immediately.

ORA-03120 : two-task conversion routine: integer overflow

Anyone seen anything similar ?

I do have TAR open currently.

Hemant Received on Wed Aug 28 2002 - 09:57:07 CDT