Tag Archives: oracle data etl

Talend Data Integration – Exception in component tOracleOutput_1java.sql.SQLException: ORA-01727: numeric precision specifier is out of range (1 to 38)

When you receive an out of range (1 to 38) error while importing from one Oracle DB to another Oracle DB

  1. Go to your tMap
  2. Locate Big Decimals and any other precision numeric values.
  3. Be sure to fill in blanks.
  4. Save your job and re-run

Fin (I hope)


Leave a comment

Filed under Sharing Stuff