|
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.
Signoff
Chris
Top posted because of limitations in the Android 2.1 Gmail client.
On Oct 5, 2010 4:30 AM, "Eirini Kakogianni" <kakogianni@gmail.com> wrote:
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