title: Cannot get the data of the row from the OLE DB provider 'ProviderName' for linked server 'LinkedServerName'
body: <p>I am running into this issue when I try to execute this query involving Linked Server to Oracle. Find the query underneath,</p>
  
  <pre><code>SELECT DISTINCT Convert(nvarchar(100),A.ZIP_CD)
                 ,Convert(nvarchar(100),A.CITY)
                 ,Convert(nvarchar(100),A.ST_CD)
                 ,Convert(nvarchar(100),E.PCT)
                 ,Convert(nvarchar(100),B.DEFAULT_DEL_CHG)
                 ,Convert(nvarchar(100),E.DEL_TAX)
  
  FROM [LIVE]..[CUSTOM].MASTER_ZIP A,
       [LIVE]..[MISC].ZONE B,
       [LIVE]..[MISC].ZIP2ZONE C,
       [LIVE]..[MISC].ZIP2TAX D,
       [LIVE]..[SALES].TAT E
  WHERE A.ZIP_CD = C.ZIP_CD
  AND ISNULL(B.DEFAULT_DEL_CHG,0) &lt;&gt; 0
  AND A.USPS_PRIM = 'P'
  AND C.ZONE_CD = B.ZONE_CD
  AND A.ZIP_CD = D.ZIP_CD
  --AND decode(D.TAX_CD,'999','99',d.tax_cd) = E.TAT_CD
  AND (Case When D.TAX_CD = '999' Then '99' Else D.TAX_CD End) = E.TAT_CD
  </code></pre>
  
  <p>Here is what I get as an error,</p>
  
  <blockquote>
    <p>Cannot get the data of the row from the OLE DB provider "OraOLEDB.Oracle" for linked server "LIVE".</p>
  </blockquote>
  
  <p>I found on a forum that said to try to convert to nvarchar as Oracle has problem converting numerics in sql server, but I still get the same error.</p>
  
  <p>Any idea on how to resolve this issue? Thanks.</p>