// From https://dev.mysql.com/doc/refman/5.5/en/c-api-prepared-call-statements.html
public void OnPluginStart()
{
	char error[255];
	Database db = SQL_DefConnect(error, sizeof(error));
	if (db == null){
		PrintToServer("Could not connect: %s", error);
		return;
	}

	/*
	CREATE PROCEDURE p1(
	  IN p_in INT,
	  OUT p_out INT,
	  INOUT p_inout INT)
	BEGIN
	  SELECT p_in, p_out, p_inout;
	  SET p_in = 100, p_out = 200, p_inout = 300;
	  SELECT p_in, p_out, p_inout;
	END
	*/

	DBStatement hStmt = SQL_PrepareQuery(db, "CALL p1(?, ?, ?)", error, sizeof(error));
	if (!hStmt){
		PrintToServer(error);
		delete db;
		return;
	}
	
	/* assign values to parameters and execute statement */
	hStmt.BindInt(0, 10); /* p_in */
	hStmt.BindInt(1, 20); /* p_out */
	hStmt.BindInt(2, 30); /* p_inout */

	if (!SQL_Execute(hStmt)){
		SQL_GetError(hStmt, error, sizeof(error));
		PrintToServer(error);
		delete hStmt;
		delete db;
		return;
	}
	
	do 
	{
		int rows = SQL_GetRowCount(hStmt); 
		PrintToServer("Num rows: %d", rows);

		int num_fields = SQL_GetFieldCount(hStmt);
		while (SQL_FetchRow(hStmt))
		{
			for (int i = 0; i < num_fields; i++)
			{
				if (SQL_IsFieldNull(hStmt, i))
					PrintToServer("val[%d] = NULL", i);
				else
					PrintToServer("val[%d] = %d", i, SQL_FetchInt(hStmt, i));
			}
		}
	}
	while (SQL_FetchMoreResults(hStmt));

	delete hStmt;
	delete db;
}