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
Problems while loading data into Oracle database using ODBC
Moderators: chulett, rschirm, roy
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.
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>