Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

java.sql.SQLException: Overflow Exception

625529Mar 26 2008 — edited Mar 27 2008

Hello everyone, I'm having a problem with ODI on an Interface excecution.
The excecution fails on the Load Data step with the following error message:

0 : null : java.sql.SQLException: Overflow Exception
"java.sql.SQLException: Overflow Exception
at oracle.sql.NUMBER.toBigDecimal(NUMBER.java:634)
at oracle.jdbc.dbaccess.DBConversion.NumberBytesToBigDecimal(DBConversion.java:2880)
at oracle.j"

I'm using Oracle as source and target technology, and i'm using the default LKM SQL to Oracle KM v4.0

I also try to run the generated SQL manualy, and it works perfectly.

What should i do?

Thanks! and sorry for my awful english!

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 24 2008

Added on Mar 26 2008

#business-intelligence-applications, #data-integrator, #system-management-and-integration

1 comment

3,328 views