Easier way to get OUT parmeters from Stored Proc call

[Jim Wallace]

I posted a method earlier that wrapped on SP with another doing a SELECT
on the OUT parameter(s).  Since then, I've found the wrapper can be
avoided by doing call and select from C++.  Here's an example with one
OUT, but can easily do more.

Query query = m_conn->query();

query <<  "CALL setPlayerBanStatus( %0q, %1q, %2, %3, @banned ); SELECT
@banned;";

query.parse();

Result res = query.store( playerName, reason, (int)(banned ? 1 : 0),
(int)bannerId ); // call SP

res = query.store_next(); // get select output

ret = res.size() > 0 && (LONG)res.at(0).at(0) != 0;