Re: HELP: strange behavior querying varchar2-field in 9i

From: Johannes Bavendiek <JohannesBavendiek_at_gmx.de>
Date: 6 Oct 2004 23:35:18 -0700
Message-ID: <df6af3e.0410062235.3b16b5b3@posting.google.com>

Meanwhile I know the reason and the solution.

Reason:
With _Oracle9_, the "blank padding" (that is, filling a CHAR field with blanks) for selecting data through a DATABASE LINK to an _Oracle8_ database has changed in such a way that the target fields are no longer filled with blanks in some circumstances. They instead contain "scrambled characters" at the end. This problem only occurs if the data is read with Open SQL, but does not occur if you use Native SQL.

Solution:
Seems to bee a Problem with SAP R/3.
There is a solution published in SAP-Note 709618. We have to install a kernel patch to our R/3-system.

Affected systems:
Problem only occurs in SAP R/3 Releases 3.1I and 4.0B with Oracle 9i, AND with DBLink to external 8i-database.

Hope this will help other people
realising the same problem.

Thanks
Johannes Received on Thu Oct 07 2004 - 01:35:18 CDT