1

Hi I have the following scenario. I am calling stored procedures to MySQL 5.x from my .NET 2 application. All stored procedures have parameters and they work fine with the exception of two which throw the following exception (only when deployed to production):

"When calling stored procedure and 'Use Procedure bodies' is false, all parameters must have their type explicitly set.

This only occurs on the "production" environment. On my development machine, everything works fine in all cases.

Any ideas? Thanks in advance, Tim

Improve this question

2 Answers 2

Reset to default
1

OK solved. I was passing DBNULL.Value as a parameter which it did not like apparently.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

1

The database account the application code is using may not have select permissions on mysql.proc. Provide the select permissions to the database account.

This blog post explains the reason in detail.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.