Please solve the problem of "Numeric Overflow"

0


Please Help me,When I am running the job to fetch data from Oracle DB table and Insert into another Oracle DB table,1310000 records are being inserted succesfully.After that it is throwing the Error "Numeric Overflow".Below is the detailed Error Code.

Please Solve it its Very Urgent.

 

Thanks,

Shikha

 

Exception in component tOracleInput_1

java.sql.SQLException: Numeric Overflow

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)

at oracle.jdbc.driver.NumberCommonAccessor.throwOverflow(NumberCommonAccessor.java:6797)

at oracle.jdbc.driver.NumberCommonAccessor.getInt(NumberCommonAccessor.java:121)

at oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImpl.java:489)

at datacollection_fact.task_fact_test.Task_Fact_Test.tOracleInput_1Process(Task_Fact_Test.java:567)

at datacollection_fact.task_fact_test.Task_Fact_Test.runJobInTOS(Task_Fact_Test.java:1212)

at datacollection_fact.task_fact_test.Task_Fact_Test.main(Task_Fact_Test.java:1128)

 

 

 

 

Code:
Exception in component tOracleInput_1
 
java.sql.SQLException: Numeric Overflow
 
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
 
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
 
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)
 
at oracle.jdbc.driver.NumberCommonAccessor.throwOverflow(NumberCommonAccessor.java:6797)
 
at oracle.jdbc.driver.NumberCommonAccessor.getInt(NumberCommonAccessor.java:121)
 
at oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImpl.java:489)
 
at datacollection_fact.task_fact_test.Task_Fact_Test.tOracleInput_1Process(Task_Fact_Test.java:567)
 
at datacollection_fact.task_fact_test.Task_Fact_Test.runJobInTOS(Task_Fact_Test.java:1212)
 
at datacollection_fact.task_fact_test.Task_Fact_Test.main(Task_Fact_Test.java:1128)
 
</td></tr></tbody></table>
shikha1610's picture
Joined: Oct 30 2008 - 3:19am
Last seen: 11 years 3 weeks ago

1 Answer:

0
From what I understand you are trying to put some values into a table. One of this tables cannot old the value you are trying to insert. Try changing some types in your oracle table to old teh value you are inputting. Ries
riesvantwisk's picture
Joined: Feb 21 2008 - 8:09am
Last seen: 2 years 11 months ago
Feedback
randomness