How to capture ORA- errors into a file or table

[Anonymous]

I am trying to find out how to capture Oracle error, like Unique Key constraint violation error eg: ORA-00001: unique constraint (SHICKL.ROW_UID_PK) violated.
I need to capture above mentioned error in to a file. Right now the above error can be visible in RUN area or execution area.
Please suggest me how do catch the ORA error in Talend in a file or table
Thanks,
Vivek Jayapalan

[Anonymous]

Hi Team,
Still rowreject count is zero. after advanced settings and deselect Use Batch Size..
Please any suggestion.

Thanks
shridhar

[Anonymous]

Create a error table with the same structure of the table with datatype of all columns as varchar2(2000) and then add 2 more columns ERRORCODE and ERRORMESSAGE again same datatype.

Add this into Talend job and then from the main table link this table with reject connector.

This works even in batch mode, I tested it. It will capture all error records including the error code and error message into the newly created error table.

Hope this helps.

Error_Capturing.png