Error Selecting Tablenames Longer Than 28 Characters Using DG4Sybase 11.1.
(Doc ID 466096.1)
Last updated on JANUARY 19, 2017
Applies to:Oracle Database Gateway for Sybase - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
***Checked for relevance on 07-Jul-2011***
Selecting from a table in Sybase with a name longer than 28 characters using Database Gateway for Sybase 220.127.116.11 on Linux gives the following error -
SELECT * FROM "TABLENAME_LONGER_THAN_28_CHARS"@sybase ;
ORA-28500: connection from ORACLE to a non-Oracle system returned this
[Oracle][ODBC Sybase Wire Protocol driver][SQL Server]The identifier that
starts with '"TABLENAME_LONGER_THAN_28_CHA' is too long. Maximum length is 28.
ORA-02063: preceding 2 lines from SYBASE
Sybase allows object names to be upto 30 characters in length.
The same select works successfully using Transparent Gateway for Sybase 10.2.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!