Employee

tOracleOutput ORA-01727

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. 

 

Capture.JPG.pngCapture.JPG

  • Data Integration
4 REPLIES
Eleven Stars TRF
Eleven Stars

Re: tOracleOutput ORA-01727

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

TRF
Employee

Re: tOracleOutput ORA-01727

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

Re: tOracleOutput ORA-01727

Was speaking about Java datatype, not Oracle.

TRF
Employee

Re: tOracleOutput ORA-01727

Below is the datatype. Thank you

 

Source and Destination (Both Oracle)Source and Destination (Both Oracle)Oracle to OracleOracle to Oracle