Work around for MySQL stored proc return a list of data issue.

Question

I'd like the stored procedure to return a list of data, just like what "select" do. But the PHP/MySql engine my hosting service does not support that feature. The only output parameter I can provide is primitive types, like int, varchar and so on.

So I tried to combine the whole list into one big string with the help from cursor.

But my query need to be dynamically generated. In mysql, I can't use dynamic query in cursor.

Any solution for that?

Thanks in advance.

Answer 1

What version of PHP and MySQL are you using, and why do they not support stored procedures returning a resultset?