Cannot Select Uniqueidentifier Columns from SQL*Server Using Database Gateway for SQLSERVER (DG4MSQL)
(Doc ID 787449.1)
Last updated on MAY 11, 2022
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.
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
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 |