My Oracle Support Banner

How to determine why certain foreign datatypes are not displayed within a select using DG4ODBC or HSODBC (Doc ID 252548.1)

Last updated on NOVEMBER 05, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.7.0 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
All Platforms

Purpose

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.

Troubleshooting Steps

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.