sql - JDBCTemplate throwing implicit conversion error while executing stored PROC -


i trying execute stored proc below :

string test = "exec insertproc @id=?,@value=?"; jdbctemplate.update(test,new object[]{object.getid(),object.getvalue()}); 

table structure :

testtable : id varchar(20) value decimal(6) 

error thrown below :

org.springframework.jdbc.badsqlgrammarexception: preparedstatementcallback; bad sql grammar [exec insertproc @id=?,@value=?]; nested exception com.sybase.jdbc4.jdbc.sybaseexception: implicit conversion datatype 'varchar' 'decimal' not allowed. use convert function run query. 

check object.getvalue output. seems returning string instead of float i.e. varchar instead of decimal. can find sample data set failing?


Comments