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

From: TurkBear <john.greco_at_dot.state.mn.us>
Date: Wed, 28 Aug 2002 12:19:44 -0500
Message-ID: <9f1qmuktdja45bm8mc43jr5hgejaeggj11@4ax.com>

If you haven't seen the detailed explanation for this error , here:

---

ORA-03120 ORA-03120ttci2u: integer overflow

Cause:An integer value in an internal ORACLE structure overflowed when being sent or received over a heterogeneous connection. This can happen when an invalid buffer length or too great a row count is specified. It usually indicates a bug in the user application.

Action:Check parameters to ORACLE calls. If the problem recurs, reduce all integer parameters (column values not included) to less than 32767.

---

May give you some place to look...

Hemant K Chitale <hkchital_nospam_at_singnet_nospam.com.sg> wrote:

>
>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

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

   http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Wed Aug 28 2002 - 12:19:44 CDT