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@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@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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
