Problems while loading data into Oracle database using ODBC

[hari4dsx]

Hello,

I am fetching my data from Oracle database,using ODBC connections.After processing ,I am trying to load it back again to the Oracle database using a different ODBC connection in a different table ,of the same user.

While loading I get the following error:

APT_CombinedOperatorController,0: [Oracle][ODBC] Numeric value out of range.

I checked the schema in the source and target table .It was fine.I also tried creating a new table in database with exactly the same schema and then tried to load the data,but still I got the same error.

Please suggest a solution to this problem.

Thanks in advance

Regards
Hari

[ArndW]

The solution is to change the datatype to accept the bigger value or change the value to fit into the datatype.

Put a reject link in your output stage and point it at a peek stage. Run the job and examine the data in error to determine which column is causing you grief.