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

Last updated on AUGUST 16, 2012

Applies to:

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

Symptoms

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

 

Cause

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 hundreds of Community platforms