Skip to Main Content

Java EE (Java Enterprise Edition) General Discussion

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!

Arithmetic overflow error converting numeric to data type numeric

843836Dec 8 2004 — edited Jan 30 2005
Hey all... I'm getting an error:

org.apache.jasper.JasperException: [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error converting numeric to data type numeric

I'm not even retrieving numeric data from my stored procedure in SQL Server 7. The procedure has an input parameter that is stored as numeric in the database table, but being passed as a string to the procedure. The parameter is then converted to numeric in the procure, but I still get that error. Been on this for three days now. Can someone please help. My deadline depends on this issue.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 27 2005
Added on Dec 8 2004
3 comments
795 views