Cannot Select Uniqueidentifier Columns from SQL*Server Using Database Gateway for SQLSERVER (DG4MSQL) (Doc ID 787449.1)

Last updated on JANUARY 19, 2017

Applies to:

Oracle Database Gateway for SQL Server - Version 11.1.0.6 to 11.1.0.7 [Release 11.1]
Information in this document applies to any platform.
***Checked for relevance on 29-Nov-2010***


Symptoms

Columns defined as datatype uniqueidentifier in SQL*Server cannot be selected using 11g Database Gateway for SQL*Server.
The columns can be selected using the 10.2 Transparent Gateway for SQL*Server.

A gateway debug trace will show something similar to the following for columns defined as uniqueidentifier datatype -

Entered hgopcda at 2009/01/26-18:12:38
Column:3(Uniqcolumn): dtype:-11 (GUID), prc/scl:36/0, nullbl:1, octet:0, sign:1, radix:10
Column 3 (Uniqcolumn): dtype -11 (GUID): this datatype is not supported.


.

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