Re: Unable to call MySQL stored procedures from Pike v7.6 release 112

Kai Voigt wrote:

a stored procedure in MySQL doesn't return anything itself, but it might include one or more SQL statements which are returned to the calling client as if those statements would have been called individually.

Note that you might have to handle multiple statements in a stored procedure.

I see. So I presume that stored procedures in MySQL are not invoked through mere SELECTs? It would imply, though, that if you stick to at most one SELECT resultset in your MySQL stored procedure, then the current Sql interface in Pike will/should suffice.

Oracle and PostgreSQL can return at most a single resultset, and are invoked through SELECT normally.