Skip to Content
0
Former Member
Apr 28, 2014 at 09:04 AM

How to handle -ve sign in JDBC SP

17 Views

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