This discussion is archived
4 Replies Latest reply: Jan 31, 2013 1:10 AM by fcjunic RSS

Different results for a SELECT statement (mismatch fields) ...client bug ?

fcjunic Newbie
Currently Being Moderated
Hi all,

I'm on Oracle DB Version 10.1.0.5.0.

I currently have 2 instances running ( INST1 AND INST2 )

On INST2 I run this statement with SQL Developer and get this result (this result is correct) :
SELECT CP,LOC,COM,RUN,SOA,INS,CP_6,ZONE FROM TLO WHERE TLO = 1234;

        CP LOC                       COM                       R SOA INS    CP_6   ZONE
---------- ------------------------- ------------------------- - --- ------ ------ ---------------
      4287 LINCENT                   LINCENT                         64047  428700 25 à 30
Always on INST2 and SQL Developer I run the "same" select statement (I only changed the position of the fields in the select) and got an curious different result :
SELECT ZONE,CP_6,INS,SOA,RUN,COM,LOC,CP  FROM TLO WHERE  TLO = 1234;

ZONE           CP_6          INS          SOA       R       COM       LOC        CP
----------    -------------- -----------  ------   ------ -------       ------- -------
       Â+X      LINCEN       LINCEN                     64047      428700     -48690069500000000000000000
If I run the statement using Toad, I got the following error message :
ORA-03106: fatal two-task communication protocol error
The table TLO is a table located on INST1 called using a public synonym defined like this :
CREATE OR REPLACE PUBLIC SYNONYM TLO FOR "TLO"@"GIPS_E"
GIPS_E is a public database link "without user" defined like this :
CREATE PUBLIC DATABASE LINK GIPS_E USING 'GIPS';
Note that running the two SQL statements using SQLPlus perfectly works ! It seems to be a client error (bug ?).

What should I check ? I already recreate the public synonym and public database link but always have the same error
Can someone help me ?

Thanks...

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points