| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-3120 querying across a DB-Link from a 9i2 db to and 8.1.7
It is a known problem; see note 19796.1 on MetaLink
-----Original Message-----
Sent: Wednesday, August 28, 2002 11:59 AM
To: Multiple recipients of list ORACLE-L
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 K Chitale
Now using Eudora Email. Try it !
My home page is : http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hemant K Chitale
INET: hkchital_at_singnet.com.sg
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Aug 28 2002 - 12:13:36 CDT
 |
 |