In order to support procedures, a SQL interface needs to support multiple results sets. While I don't have specific knowledge of LuaSQL, I do know that other software (e.g. Postfix) doesn't support procedures for this reason.
Top posted because of limitations in the Android 2.1 Gmail client.
On Oct 5, 2010 4:30 AM, "Eirini Kakogianni" <email@example.com> wrote:
I am trying to call a very simple stored procedure in mysql using
LuaSQL. The procedure is:
CREATE PROCEDURE get_time()
But when I try to call the procedure in Lua by conn:execute("CALL
get_time()") I get an error:
LuaSQL: error executing query. MySQL: PROCEDURE
availability_tool.get_time can't return a result set in the given
Any idea what can be causing this? Is returning result sets from
procedures not supported by LuaSQL?
I appreciate your help.