It seems that the DBI API cannot handle multiple result sets from stored procedures.
Executing queries like the one below will always fail:
dbi_query(dbhandle,"call MyStoredProc('Some input','Some more input')");
The query above works only if the stored procedure does not return anything. If it returns something, it will always fail.
I know that other APIs (like for example PHP and its mysql_query()) also had this problem. However in PHP it was possible to set client options, so that it would accept result sets from a stored procedure.
Is there a way to get around this problem in DBI API in AMX MOD X?
P.S
Since SQLX also has the same issue a new thread was created to deal with this problem in general.
The discussion is continued here
http://forums.alliedmods.net/showthread.php?t=54852