How to determine why certain foreign datatypes are not displayed within a select using DG4ODBC or HSODBC
(Doc ID 252548.1)
Last updated on SEPTEMBER 27, 2019
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Sometimes a select using Database Gateway for ODBC (=Dg4ODBC) does not show all columns present in a remote's foreign database table. In most cases this problem is because of an unsupported data type.
In releases 8i, 9i and 10gR2, 11gR1, 11gR2 unsupported data type columns are dropped from a select list; in 10GR1 an error occurs.
This note shows how to determine the datatype of a column and how to verify if it is a supported or unsupported data type.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!