RE: ORA-3120 querying across a DB-Link from a 9i2 db to and

Inka Bezdziecka,

oops ... my previously reply wasn't complete and didn't indicate the right context. My apologies if the reply wasn't very clear.

As I have logged a TAR with Oracle Support, I was waiting for a reply from Oracle. That is why I put in the line "Both are Oracle products and I expect an Oracle reply." I have generated a client-side [the Windows SQLPlus 8.0.6 side] Trace File and uploaded into the TAR.

Regards
Hemant

I had said :
> > Thanks for pointing out the Note.
> > However, Note 19796.1 isn't very helpful.
> > It does talk of buffersize, and I have tried changing
> > the Arraysize (but not the buffersize) in sqlplus.
> > The note seems to indicate that the problem could be in
> > the client application.
> > When querying across a db-link, which would be the client ?
> > The database where the db-link exists (9.2.0.1) or the
> > SQLPlus (8.0.6 on Windows) where the query is fired ?
> > Both are Oracle products and I expect an Oracle reply.

At 09:13 AM 28-08-02 -0800, you wrote:
>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).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Inka Bezdziecka
> INET: IBezdziecka_at_cupe.ca
>
>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).

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