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 and later
Information in this document applies to any platform.


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


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

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