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 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) )
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
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
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
Symptoms |
Cause |
Solution |
References |