SQL Server Linked Server Returns Different Records than Another Application Executing the Same SQL Statement (Doc ID 1319068.1)

Last updated on NOVEMBER 13, 2019

Applies to:

Oracle Provider for OLE DB - Version 9.2.0.1 and later
Microsoft Windows (32-bit)
Microsoft Windows x64 (64-bit)
SQL Server Linked Server
TOAD

Executing the same query based on a VIEW returns different record counts based on the application used.

SELECT count(*) FROM MyView

SQL*Plus (or TOAD) returns 1,329 rows
SQL Server Linked Server (using the Oracle Provider for OLE DB) returns 1,789 rows

	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

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