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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy