Hi ,
We have sending -ve value to JDBC stored procedure where the SP type is DECIMAL.but, its giving error that "number format exception caught".
I think DECIMAL type will not be able to convert -ve sign. How can i handle this..?
ex:
input value = 2345.00-
required output in JDBC SP is : 2345.00-
used type in SP structure : DECIMAL
Should i change SP type to some other data type to handle -ve sign ? how to do that ?
plz help
Vin