tOracleOutputBulk generates numbers in scientific notation

antonio-fuentes — Sat, 16 Nov 2024 03:23:53 GMT

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?

Thank you very much in advance.

Best regards,

Antonio

Re: tOracleOutputBulk generates numbers in scientific notation

akumar2301 — Fri, 31 Jan 2020 19:11:15 GMT

Just can you confirm the if precision scale is defined on oracle .

This is to know if your oracle table accept 0.0000000012345678 value.

Re: tOracleOutputBulk generates numbers in scientific notation

antonio-fuentes — Fri, 31 Jan 2020 21:00:59 GMT

No, precision is not defined in Oracle nor in Talend.

Datatype is BigDecimal in all 3 components in Talend.

Datatype is NUMBER in Oracle and the Oracle table does accept 0.0000000012345678.

Regards,

Antonio

topic Re: tOracleOutputBulk generates numbers in scientific notation in Talend Studio

tOracleOutputBulk generates numbers in scientific notation

Re: tOracleOutputBulk generates numbers in scientific notation

Re: tOracleOutputBulk generates numbers in scientific notation