 Get data back from mysql stored procedure call
Is there any way to get data back from a call to a mysql stored procedure? I am able to call the stored procedure just fine, but when I try to use types OUT or INOUT to return data/results the call to the stroed procedure fails because the data being passed into the stored procedure is being interpreted as a literal rather than as a variable.
Any ideas?
This is the error:
[MySQL][ODBC 5.1 Driver][mysqld-5.1.30]OUT or INOUT argument for routine xxxx is not a variable or NEW pseudo-variable in BEFORE trigger.
|