Post reply

Cannot get the data of the row from the OLE DB provider "OraOLEDB.Oracle" for linked server

  • October 24, 2013 at 10:51 am

    #299507

    I am periodically getting the following message when I attempt to query my linked server:

    Cannot get the data of the row from the OLE DB provider "OraOLEDB.Oracle" for linked server

    Upon examining my stored procedures, it appears to only happen when a WHERE clause is used, leading me to wonder if there is a problem with the data. What exactly does this error refer to? Where should I begin looking? I realize that I'm not giving much information, but I'm not really sure where to begin looking.

  • 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?

  • March 22, 2016 at 1:20 pm

    #1866925

    Hello, Use 'Like' Instead of '='

    Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply