Hi All, I am having a Global Temporary table which will have one row and that contains date columns. I want to truncate the table and insert a new value in to the table. To accomplish this i have a simple truncate statement and followed by an Insert statement. To do this initially i had used 2 tOracleRow's components, one having Truncate statement and the other one having Insert Statement and linked with OnSubjobOk from first component to second component. Now i run the job, the job executes successfully with out any errors but when i check the Global Temporary table my desired out put is not present. I am not getting where to debug, there is no error in job but the new row is not inserted. After reading some topics in our forum i had gone for another approach i had created a stored procedure compiled it successfully and used tOracleSP and had given the SP name in the component and executed my job but the same result. My point is i am not getting any error then why the desired out put is not shown in my table finally when the job is completed Any Ideas please?, Kindly help me.
TRUNCATE TABLE edw.temp_daily_finance_rpt_cal; (Global Temporary Table) INSERT INTO edw.temp_daily_finance_rpt_cal SELECT time_id, calendar_date FROM edw.dim_time WHERE calendar_date >= to_date(trunc(sysdate)) - 1 AND calendar_date <= to_date(trunc(sysdate)) - 1; (dim_time --- just a look up table which will have date and years)
The above are the statements which i use in my SP or tOracleRow components Thanks and Regards, Pavan
Hi Janhess,
Even if there is a commit it doesn't make much diff, because i any way Truncate the table first before inserting the new record.
But how to handle my situation do you have any idea or have you faced any issue like this earlier?
Kindly help me
Hi Janhess,
Yup the Select is not returning any value, but id i run the same Select in SQL developer out put is coming. Why?
How to fix this in Talend?
Thanks and Regards,
Pavan
