MySQL Forums
Forum List  »  Stored Procedures

Re: Error: "Procedure X can't return a result set in the given context"
Posted by: Per-Erik Martin
Date: October 18, 2005 11:04AM

"IN" is the default, so it doesn't make any difference if you type it explicitly or not. It's only allowed by the standard for clarity (I presume).
And like I said, "return a result set" is about sending back a result to the client from a SELECT (or some other statements which also behave
like SELECT, SHOW for instance), not about returning data through (out) parameters for instance.

Since you say that "Invoking the procedure using the 'mysql' interactive client did not generate this error in either case.", it's apparently
a problem with whatever client you are using.

pem, Senior Software Dev., MySQL AB

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.