Is it Possible to Call Stored Procedures via SimpleQuery ?

[Phil89a]

I am trying out MySQL-NIO and I want to be able to call a Stored Procedure from my MySQL database and return the result set to my Swift application, however the SimpleQuery is failing with...

MySQL error: Server error: PROCEDURE Accounts.display_Transactions can't return a result set in the given context

The Stored Procedure only has one select, so it is only returning one result set. If I replace the call with the actual SQL from the Stored Procedure it works.

Is it possible to call a Stored Procedure in this way - or is there another method I should be using ?

thanks

Phil

[0xTim]

cc @gwynne

[gwynne]

It is currently not possible to call a stored procedure using MySQLNIO at all; there is no implementation of the CLIENT_MULTI_RESULTS capability yet. It's on my TODO list 😕.

[Phil89a]

Ah pity as I need to keep most of my logic on the server. Not having Stored Procedures means lots of client side logic and SQL statements :(

Hopefully something that can be added soon ?

[gwynne]

Yeah, I'm hoping to get to it in the next couple of weeks.

[Phil89a]

Excellent - I can survive until then :-)

[whiterockstudios]

I would also love to have this 😃

[pingrami]

when calls to stored procedures will be supported?

[sunpeakstudio]

Any idea if calling stored procedure from Vapor will ever be available?

[0xTim]

ping @gwynne