Arithmetic overflow error converting numeric to data type numeric
843836Dec 8 2004 — edited Jan 30 2005Hey 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.