5 Replies Latest reply: May 4, 2017 1:52 AM by Rahul Pawar RSS

    OLEDB read failed message

    Arshad Hussain

      Why I am getting the following message

       

      OLEDB read failed

      AERO_BILLING_DATA:

      SQL SELECT T1.*,T2.*,T3.*

      FROM AR."RA_CUST_TRX_LINE_GL_DIST_ALL" T1 RIGHT OUTER JOIN AR."RA_CUSTOMER_TRX_ALL" T2 ON T1.CUSTOMER_TRX_ID=T2.CUSTOMER_TRX_ID

      RIGHT OUTER JOIN AR."RA_CUSTOMER_TRX_LINES_ALL" T3 ON T1.CUSTOMER_TRX_ID=T3.CUSTOMER_TRX_ID

      where TO_CHAR(T1.GL_DATE,'RRRR') >=EXTRACT(YEAR FROM SYSDATE)-4 AND T1.ORG_ID=85 and T1.account_class='REV'

       

      while the above same query is working fine in Sql Developer.