LuaSQL: problem calling mysql stored procedure

[Eirini Kakogianni <kakogianni@...>]

Hello,

I am trying to call a very simple stored procedure in mysql using
LuaSQL. The procedure is:

DELIMITER $$
CREATE PROCEDURE get_time()
BEGIN
       SELECT_NOW();
END$$
DELIMITER ;

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
context

Any idea what can be causing this? Is returning result sets from
procedures not supported by LuaSQL?

I appreciate your help.

Kind regards,
Eirini