My Oracle Support Banner

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 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 on Linux gives the following error -


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!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.