Nov 12th, 2009, 02:18 AM
SimpleJdbcCall calling function using different param name to store and retrieve valu
I am using Spring 2.5.6 SEC1 and SQL Server 2008
When I use SimpleJdbcCall to call a stored function and trying to retrieve value but I always get null.
Then I used debug, I found out that Spring uses a OutputParameter named "RETURN_VALUE" to store the returned value from the SQL Function (I do get a correct value) however when retrieving the value, Spring uses "return" to retrieve it which will never get the correct value.
Is this a bug? or am I suppose to set something before calling the Function?
Tags for this Thread