Results 1 to 1 of 1
- 02-10-2012, 09:03 PM #1
Senior Member
- Join Date
- Jan 2012
- Posts
- 210
- Rep Power
- 2
Stored procedure OUT parameter is rounded
Say there is stored procedure:
While getting OUT parameter, say:XML Code:PROCEDURE `get_price`(OUT PRICE_X DECIMAL(10.2))
result is:Java Code:CallableStatement cstmt = conn.prepareCall("{call get_price(?)}"); cstmt.registerOutParameter(1, 6); System.out.println(cstmt.getFloat(1));but field value in database table is :Java Code:778.0
Why is that value rounded, when I used sqlType 6 = FLOAT?Java Code:777.77
How to get exact value as it is in database table field?
Similar Threads
-
SQL EXception- in Stored Procedure call
By cnu.nandhikonda@gmail.com in forum JDBCReplies: 3Last Post: 02-08-2012, 01:52 PM -
java call stored procedure
By namalsera in forum JDBCReplies: 1Last Post: 01-04-2011, 03:53 PM -
Debug mySql stored procedure
By ulix83 in forum NetBeansReplies: 0Last Post: 10-29-2009, 11:48 AM -
stored procedure
By sankarigopi in forum JDBCReplies: 1Last Post: 11-13-2008, 04:53 PM -
How to get multiple rows from Stored Procedure
By SRJ1957 in forum Advanced JavaReplies: 0Last Post: 08-11-2008, 08:26 PM


LinkBack URL
About LinkBacks
Reply With Quote
Bookmarks