Executing queries like the one below will always fail:
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 tried using both DBI and SQLX - both have the same problem.
SQLX returns an error: PROCEDURE MyStoredProc can't return a result set in the given context
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 AMX MOD X?