ORA-3120 two-task conversion routine: integer overflow

[townsendEbmud]

This seems to be a cross-database query problem. I'm querying from an Oracle 9.2.0.2 database to an 8.1.7 database. Here is the SQL:
------------
select "SERV_NU",
"OCCP_NU",
"CUST_CMNT_DT",
"CUST_CMNT_TYPE_CD",
"CUST_CMNT_TX",
"CUST_CMNT_RETN_CD" from extload.cis_cmnt@eprdwhse
where serv_nu='2261250' order by cust_cmnt_dt
------------
Result: ORA-3120 two-task conversion routine: integer overflow.

This query works OK in SQL*Plus and ColdFusion. The documentation suggests the problem is in the calling program (PLSD). Requesting PLSD be fixed.

BTW: PLSD is great. Everyone here loves it.

 

[Marco Kalter]

Can you go to Help > About, press the 'Info' button, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply?

 

[townsendEbmud]

Per request, Info pages have been emailed separately.

 

[Marco Kalter]

We have not received them. Can you resend?

 

[townsendEbmud]

Resent to support@allroundautomations.com. Is there another address I should use?

 

[Marco Kalter]

We have again not received anything. Did you receive any spam bounce e-mail? Can you send me a "normal" e-mail without the information?

 

[simduss]

Hi,
I have the same problem. I have a 9.2.0.1.0 database towards a 8.1.7.4.0 database thru a DB_LINK.

Here is my query: SELECT * FROM COM_UTIL@OR1A@PRD.
I must specify that the error ORA-03120 occurs when:
-the query retreive more than 1 row;
-the query use *. If I enumrate the fields that I want to select = no error;
-I use SQL*Plus 8.0.6. If I use SQL*Plus 3.3.4 (Client 7)= no error.

Do you have an explanation and/or a solution?

Thanks

 

[Marco Kalter]

I'm having some problems obtaining the info from townsendEbmud, so I will ask you the same:

Can you go to Help > About, press the 'Info' button, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply?

 

[townsendEbmud]

Just to clarify -- it's technical email problems, not problems with townsendEbmud himself!

 

[simduss]

1

 

[simduss]

It seems to be linked with client version. With a client 8.0.6 the error occurs. With a client version 8.1.7 the error not occurs. We suppose that client 8.1.7 support 9i database.

Thank you for your help.

 

[townsendEbmud]

FYI, the original problem I posted has gone away in the 6.0 version of PLSD. Thanks!