Char and Text Columns Tripled in Length Using DG4Sybase and ORA-600 [space leak] Errors After Installing Patch 12531175
(Doc ID 1340610.1)
Last updated on MAY 11, 2022
Applies to:
Oracle Database Gateway for Sybase - Version 11.2.0.2 and laterInformation in this document applies to any platform.
Symptoms
After applying patch 12531175 on top of Oracle RDBMS 11.2.0.2.2 CHAR and TEXT fields selected through Database Gateway for Sybase (DG4SYBS) are triple the original length, filled with spaces.
Before applying the patch:
SQL> select dump(charfield) from table@sybase;
Typ=96 Len=50: 77,71,87,51,48,32,32,32,... (padded with spaces until the length of 50)
Typ=96 Len=50: 77,71,87,51,48,32,32,32,... (padded with spaces until the length of 50)
After applying the patch:
SQL> select dump(charfield) from table@sybase;
Typ=96 Len=150: 77,71,87,51,48,32,32,32,... (padded with spaces until the length of 150)
Typ=96 Len=150: 77,71,87,51,48,32,32,32,... (padded with spaces until the length of 150)
Additionally, numerous ORA-600 errors might be noticed:
ORA-00600: internal error code, arguments: [729], [1418768], [space leak], [], [], [], [], [], [], [], [], []
Changes
Applying patch 12531175 on top of Oracle RDBMS 11.2.0.2.2
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |