tOracleOutputBulk generates numbers in scientific notation
Hi,
We are facing the following problem on Talend 6.3.1: the tOracleOutputBulk component is generating some numbers in a scientific notation format in the .blk file. This only happens for those numbers with more than 12 figures after the decimal point.
1) We get some numeric data (defined as BigDecimal) in a tOracleInput component. For example: 5.12345678 and 0.0000000012345678.
2) We pass that data to a tMap to add some other data without manipulating the numeric data.
-> If we put a tLowRow at this point, all numeric data is still in the correct format: 0.12345678 and 0.0000000012345678.
3) We pass all data to the tOracleOutputBulk.
-> The .blk file generated contains lines with the correct format (5.12345678) and lines with the scientific notation format (0.0000000012345678 has become 1.2345678E-9)
These lines are provoking an ORA-01722 error (invalid number) while trying to insert them with a tOracleBulkExec component.
This also happens with the tOracleOutputBulkExec component.
Searching on the tOracleOutputBulk and tOracleOutputBulkExec manual pages, we have not found any settings with allow to get all data without the scientific notation format in the .blk file.
Have you ever faced this kind of problem?
Is there any kind of configuration in these components to avoid having numbers in scientific notation in the .blk file?
