LuaSQL: problem calling mysql stored procedure
[
Date Prev][
Date Next][
Thread Prev][
Thread Next]
[
Date Index]
[
Thread Index]
- Subject: LuaSQL: problem calling mysql stored procedure
- From: Eirini Kakogianni <kakogianni@...>
- Date: Tue, 5 Oct 2010 13:28:32 +0200
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