Say there is stored procedure:
XML Code:
PROCEDURE `get_price`(OUT PRICE_X DECIMAL(10.2))
While getting OUT parameter, say:
Java Code:
CallableStatement cstmt = conn.prepareCall("{call get_price(?)}");
cstmt.registerOutParameter(1, 6);
        System.out.println(cstmt.getFloat(1));
result is:
Java Code:
778.0
but field value in database table is :
Java Code:
777.77
Why is that value rounded, when I used sqlType 6 = FLOAT?
How to get exact value as it is in database table field?