Calling mysql Stored proc throws error

[namitrs]

Hello

I am trying to call a mySql Stored Proc from CR10. But I get the attached error msg. I tried testing and SP runs fine when it doesnt output any value to a variable. The SP runs perfectly fine in the query browser. But when I try to call a Stored Proc which outputs value to output parameter I get the error -
"Failed to retrieve data from the database.Commands out of
sync; you can't run this command now"

Has anyone faced the same issue
Thanks

 

[Madawc]

Are you using a new version of SQL? Sometimes a command that used to work will no longer be accepted. If it isn't obvious which, comment out selectively until you find it.

If you do find it, post it and see if anyone can help.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[namitrs]

I am not sure what do you mean by 'new version of SQL'.
I am using Mysql 5.17 and CR 11.5 and the command I give to run the SP is the following -

call spname (input param, @output param);

the same cmd works perfectly fine when i run the sql browser but throws error when being run in CR.

 

[Madawc]

Sorry, this is outside of my experience. Can anyone else help?

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP