HELP: strange behavior querying varchar2-field in 9i

Hi there,

I need help.

Situation of error:
° Two Systems running:

1. R/3-System with Oracle 8i (SID Sap1) Sap1 recently upgraded from 8i. Definitely NO changes in R/3-instance.
2. nonSAP-System with Oracle 9i (SID Ora1).
   ° Existing DBLINK in Sap1 connecting to Ora1-database.
   ° Existing Synonym Sap1 referencing table "Tab1" in database Ora1 via DBLINK.
   ° Tab1.field10 is defined varchar2(10).
   ° All values in Tab1.field10 are filled with axactly 7 characters.
   

°Querying the field from R/3 brings strange and varying results like "S002003% S", "S002003E#è", "S002003Ö_v". Meaning the 7 correct characters and 3 trailing "trash"-characters.

additional information:
° With Sap1 in Version 8i over years we always got the expected result:
  "S002003 " <-- three trailing blanks

I tried this:
1. drop and create synonym and drop and create dblink without success. 2. Querying with SQLPLUS from R/3-server brought "S002003"   (without trailing blanks),
  with 8i and with 9i.

Behavior of 9i seems to be different compared to 8i. Does anyone know why this happens?
Does anyone know how to get correct results?

Thanks in advance.

Johannes Received on Wed Oct 06 2004 - 07:30:28 CDT