Re: C Api executing Stored Procedures

[Andrew Gilfrin]

Craig.

I did sort of understand what you wanted to do but glossed over it as I don't know the answer :) (I don;t think anybody does at the moment). Not wanting to be critical of Stored Procedures but it seems as if they have been designed so that MySQL can say they have them, currently there doesn't seem to be a great deal of support when calling them from another language or an API.

Your correct in that you can't return a result set as you can with other database procedural languages. The comment in the documentation is a bit misleading. It depends on your definition of a results set, what the comment refers to is a set of results as if you just called an SQL statement. What I would term a results set would be something in the parameter list that will pass back the results to the calling procedure (MySQL stored procedure, API etc).

I don't know a great deal about the API so I can't really comment on it too much. I think the CLIENT_MULTI_RESULTS stuff is more to do with the parser than anything usefull at this stage. If you just issued a SELECT via the API how do you handle the rows that come back, can you do the same thing for the procedure?

Andrew Gilfrin
http://www.mysqldevelopment.com