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 laterMicrosoft Windows (32-bit)
Microsoft Windows x64 (64-bit)
SQL Server Linked Server
TOAD
Symptoms
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
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 |