Error Selecting Tablenames Longer Than 28 Characters Using DG4Sybase 11.1.
Last updated on JANUARY 19, 2017
Applies to:Oracle Database Gateway for Sybase - Version 220.127.116.11.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 18.104.22.168 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