My Oracle Support Banner

Querying ALL_TAB_COLUMNS Using Database Gateway for Sybase (DG4Sybs) Doesn't Show Sybase Userdefined Data Types (Doc ID 1480134.1)

Last updated on SEPTEMBER 20, 2021

Applies to:

Oracle Database Gateway for Sybase - Version to [Release 11.2]
Information in this document applies to any platform.


When using Database Gateway for Sybase (DG4SYBS) and selecting from ALL_TAB_COLUMNS then Sybase userdefined data types are missing.
For example, create a user defined datatype in Sybase -

exec  sp_addtype 'xName' , 'varchar(45)' , nonull


and this is used in a Sybase create table statement -

create table test (
column1                 xName                            not null  ,

column2 varchar(5)  )


then the 'column1' column will not show when selecting from ALL_TAB_COLUMNS for the table test.

SQL> desc test@sybase     <--- shows correct columns
SQL> select * from test@sybase ;       <--- returns correct data for all the columns
SQL> select column_name from all_tab_columns@sybase where table_name = 'test';     <--- only shows column2



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

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