Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Are you sure that you have set up your OLEDB connection correctly?
Andy
Hello Arshad,
As a workaround, please refer below script:
AERO_BILLING_DATA:
SQL SELECT *
FROM AR."RA_CUST_TRX_LINE_GL_DIST_ALL"
WHERE TO_CHAR(GL_DATE,'RRRR') >=EXTRACT(YEAR FROM SYSDATE)-4 AND ORG_ID=85 and account_class='REV';
RIGHT JOIN
RA_CUSTOMER_TRX_ALL:
SQL SELECT *
FROM AR."RA_CUSTOMER_TRX_ALL";
RIGHT JOIN
RA_CUSTOMER_TRX_LINES_ALL:
SQL SELECT *
FROM AR."RA_CUSTOMER_TRX_LINES_ALL";
//OR else you can use below script
tmpAERO_BILLING_DATA:
SQL SELECT *
FROM AR."RA_CUST_TRX_LINE_GL_DIST_ALL";
RIGHT JOIN
RA_CUSTOMER_TRX_ALL:
SQL SELECT *
FROM AR."RA_CUSTOMER_TRX_ALL";
RIGHT JOIN
RA_CUSTOMER_TRX_LINES_ALL:
SQL SELECT *
FROM AR."RA_CUSTOMER_TRX_LINES_ALL";
AERO_BILLING_DATA:
LOAD *
Resident tmpAERO_BILLING_DATA
WHERE YEAR(GL_DATE) >= YEAR(TODAY()) - 4 AND ORG_ID=85 and account_class='REV';
DROP Table tmpAERO_BILLING_DATA;
Hope this will be helpful.
Regards!
Rahul
Yes, take a look yourself
Connecting to Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=abcro;Data Source=192.176.0.220/test2:1521;Extended Properties=""
Connected
Not working as required
What is the current result and expected outcome?
Regards!
Rahul