My Oracle Support Banner

Query Over Oracle Gateway Fetching Incomplete Results (Doc ID 1381197.1)

Last updated on MAY 11, 2022

Applies to:

Oracle Database Gateway for SQL Server - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms

When selecting via dblink remote data, no problem, but when retrieving data
via pl/sql using passthrough, a varchar2 variable collecting data from SQL
Server varchar(5000), that Oracle sees as LONG, only the first character is
returned

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.