MySQL Bugs: #6668: Integer "out" parameter from stored procedure returned as string

Bug #6668	Integer "out" parameter from stored procedure returned as string
Submitted:	16 Nov 2004 19:34	Modified:	31 Jan 2005 22:19
Reporter:	Paul Hyman
Status:	Closed
Category:	Connector/Net	Severity:	S2 (Serious)
Version:	1.0.2	OS:	Microsoft Windows (Windows 2000)
Assigned to:	Reggie Burnett	Target Version:

Description:
I have a stored procedure which has an integer (int32) out parameter.  When I add the
parameter, I specify a DbType of Int32.  However, the returned value comes back as the
correct value, but as a string.  I realize I can use Int.Parse to convert it, but for the
time being I need to be compatible with both Oracle and MySql and Oracle returns the value
as an integer.  As a workaround, the returned value type can be checked and converted
appropriately.  I am using the 5.0.1 version of the server.

How to repeat:
Create a stored procedure that returns an integer parameter and examine the returned
parameter's data type.

Suggested fix:
N/A

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html