Home Forums SQL Server 2008 Working with Oracle Cannot get the data of the row from the OLE DB provider "OraOLEDB.Oracle" for linked server RE: Cannot get the data of the row from the OLE DB provider "OraOLEDB.Oracle" for linked server
Mark Harley
SSCrazy
Points: 2259
More actions
October 24, 2013 at 10:55 am
#1661388
The problem seems to be resolved by trimming the field used in the WHERE clause, although I'm not sure why. The field is a INT, but when I apply an LTRIM and an RTRIM, the query works. Why would this be the case?