Problems while loading data into the Oracle database

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
hari4dsx
Participant
Posts: 14
Joined: Wed Feb 13, 2008 4:53 am

Problems while loading data into the Oracle database

Post by 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
Hari
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Hari - posting a question two times will not double the speed you get answers. Posting a PX/EE question like this in a server forum will not get you any answers at all. Stick with the question you asked here
Post Reply