My Oracle Support Banner

ORA-28528 When Selecting Several Consecutive Times Via Gateway 11g (Doc ID 1052017.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle Database Gateway for SQL Server - Version 11.1.0.7 to 11.2.0.3 [Release 11.1 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 09-Jan-2013***

Symptoms

On 11.1.0.7 version and 11.2, Database Gateway for MS SQL (DG4MSQL).

When attempting to execute a SELECT on different tables, after 7 consecutive SELECT statements, the following error occurs.

It works without any problem in 11.1.0.6

ERROR
-----------------------
ORA-28528 Heterogeneous Services Datatype Conversion Error
ORA-2063 ORA-02063: preceding line from


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Select * from table@dblink where rownum>2
2. Select column1, column2 from table@dblink where rownum>2

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.