topic Re: tOracleOutput ORA-01727 in Talend Studio

tOracleOutput ORA-01727

Anonymous — Sat, 16 Nov 2024 09:27:09 GMT

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.

Re: tOracleOutput ORA-01727

TRF — Thu, 03 Aug 2017 18:09:18 GMT

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

Re: tOracleOutput ORA-01727

Anonymous — Thu, 03 Aug 2017 23:25:34 GMT

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

Re: tOracleOutput ORA-01727

TRF — Fri, 04 Aug 2017 07:12:38 GMT

Was speaking about Java datatype, not Oracle.

Re: tOracleOutput ORA-01727

Anonymous — Tue, 08 Aug 2017 05:08:12 GMT

Below is the datatype. Thank you

Source and Destination (Both Oracle)Oracle to Oracle

Re: tOracleOutput ORA-01727

Anonymous — Fri, 06 Dec 2019 17:22:23 GMT

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)

Re: tOracleOutput ORA-01727

Anonymous — Fri, 06 Dec 2019 19:10:16 GMT

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