Potential Bug : Handling large numbers

[ossDataEngineer]

Hello Hop Team,

I have a incoming string datapoint with value = "10000000000000000.00"

I am trying to save it inside Oracle Column with datatype NUMBER(18,2).

Get the following error: ORA-01438: value larger than specified precision allowed for this column when inserting data using table output transform.

I applied metadata conversion (using select values transform) to convert original datatype of column from string to 'number' and 'bignumber' with length=16 and precision=2. The value projected after select values transform is unaffected by the precision conversion and so oracle db complains.

Question: Is the metadata conversion not working properly?

Thanks!

[dmainou]

It can get quirky at times if you don't get things exactly right.

Do me a favour add a calculate step and make a copy of your string as a number with the required characteristics.

Then use a select to remove, rename and reorganise and try again

[dave-csc]

If you copied the number correctly, it has nineteen digits in total, hence the Oracle error (a NUMBER(18,2) allows you to store an eighteen-digit number, of which two digits are decimal, with rounding if your actual data has more than two decimals)

Check the Oracle Documentation for numeric data types for more details.

Hope this helps :)