Hi,

We are using talend in our projects for various batch programs. So far we had these batches in PL/SQL and currently we use talend for them.

My question is , how to capture the error in detail?. Because for unique or integrity or any other constraints, the job simply says error occurred during the job and doesn't give out the full exception.

It becomes more difficult to trace out the error in these scenarios.

I tried to check the option "Die on error" on the "tOracleOutput" & "tdb2OutputNode". But even then, i didn't get the exact error message, it gave me some exception details and said to use "getNextException()" method.

Requesting help..