Last updated on JANUARY 19, 2017
Applies to:Oracle Database Gateway for Sybase - Version 126.96.36.199.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 188.8.131.52 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms