tOracleOutput ORA-01727

[Anonymous]

Hi,

I did a simple tOracleInput to tOracleOutput. I got error

tOracleOutput_1 ORA-01727: numeric precision specifier is out of range (1 to 38).

My input source has only 28 and the output schema was sync.

I checked online that ORA-01727 can be resolved by sspecifying a NUMERIC datatype which is a precision value between 1 and 38.

https://www.techonthenet.com/oracle/errors/ora01727.php

I should not need to do this since the source and target Oracle database is the same.

Any suggestions? Thank you very much. 

[TRF]

Hi,
What's the datatype for the corresponding field into the Talend schema?

[Anonymous]

It is the same. It is direct move and no transformation. The "sync" was used in the second component.

[TRF]

Was speaking about Java datatype, not Oracle.

[Anonymous]

Below is the datatype. Thank you

Source and Destination (Both Oracle)Oracle to Oracle

[Anonymous]

La solución está en verificar tus campos destino, en aquellos que el tipo sea byte,short,int,long,float y double (Númericos), y verificar que su longitud se encuentre entre (1-38) 

[Anonymous]

Hi,

    Could you please try to use numeric as DB data type from Oracle Input component itself?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved