MySql Stored Procedure

ID:160430
 
Sep 13 2008, 12:11 am (Edited on Sep 13 2008, 6:45 am)
I am using stored procedures in my game and I can get Update,Insert and delete statement to work, but I can not get select statements to work. I keep getting this mysql error

"can't return a result set in the given context"

There really isn't much talk about mysql interaction on the forum so I doubt I will get much help, but here is the connection code and the stored proc
mob
    verb
        Test()
            var/DBConnection/dbcon=new()
            var/DBQuery/query
            dbcon.Connect("dbi:mysql:byond:localhost:3306","User","Pass")
            query = dbcon.NewQuery()
            query.sql={"
                call StoredProc();
            "}
            var/success = query.Execute(query.sql)
            if(!success)
                world.log<<query.ErrorMsg()
                return
            else
                usr<<"worked"


create stored procedure

DELIMITER $$

CREATE
    PROCEDURE `byond`.`StoredProc`()

    BEGIN
    select * from TestTable;
    END$$

DELIMITER ;


If you can not help me maybe you could explain how byond actually interacts with mysql, because this procedure works fine when executed directly through mysql.