You are probably seeing this error as you attempt to transfer data with many date values from one Oracle database to another Oracle database using Talend Studio.
Well quick fix (not sure why it works) is to decrease the commit size in your OracleOutput node. The default is 10,000. I reduced mine to 500. See illustration below.
Comments are always welcome.