how to get result set from calling procedure?

[Gary li]

Hi,all
I am using Mysql 5.0 But I get an error message for calling procedure
with mysql_query().
My program is shown below:
Thank & Regard.
Gary.

#define W32_LEAN_AND_MEAN
#include <windows.h>
#include <mysql.h>
#include <stdio.h>
#include <string>

int main(int argc, char** argv)
{
MYSQL* sqlid = mysql_init(0);
if (!mysql_real_connect(sqlid, "localhost", "test", "test", "test", 0,
0, CLIENT_MULTI_STATEMENTS)) {
printf("%s\n", mysql_error(sqlid));
mysql_close(sqlid);
return -1;
}
sqlid->reconnect = 1;
std::string proc = "call pro_ins_department(10, 'test',
'testprocedure')";
if (0 != mysql_query(sqlid, proc.c_str())) {
printf("operator failed:%d %s\n", mysql_errno(sqlid),
mysql_error(sqlid));
} else {
MYSQL_RES * rs = mysql_store_result (sqlid);
MYSQL_ROW row = mysql_fetch_row(rs);
unsigned __int64 id = (unsigned __int64)atoi(row[0]);
printf("get id:id=%d\n", id);
}
mysql_close(sqlid);
return 0;
}

[lark]

Gary li wrote:

Hi,all
I am using Mysql 5.0 But I get an error message for calling procedure
with mysql_query().
My program is shown below:
Thank & Regard.
Gary.

#define W32_LEAN_AND_MEAN
#include <windows.h>
#include <mysql.h>
#include <stdio.h>
#include <string>

int main(int argc, char** argv)
{
MYSQL* sqlid = mysql_init(0);
if (!mysql_real_connect(sqlid, "localhost", "test", "test", "test", 0,
0, CLIENT_MULTI_STATEMENTS)) {
printf("%s\n", mysql_error(sqlid));
mysql_close(sqlid);
return -1;
}
sqlid->reconnect = 1;
std::string proc = "call pro_ins_department(10, 'test',
'testprocedure')";
if (0 != mysql_query(sqlid, proc.c_str())) {
printf("operator failed:%d %s\n", mysql_errno(sqlid),
mysql_error(sqlid));
} else {
MYSQL_RES * rs = mysql_store_result (sqlid);
MYSQL_ROW row = mysql_fetch_row(rs);
unsigned __int64 id = (unsigned __int64)atoi(row[0]);
printf("get id:id=%d\n", id);
}
mysql_close(sqlid);
return 0;
}

you have to make sure that you the username you're using has execute
privileges on that stored procedure in the database you're connecting
to. otherwise, it looks ok to me.

[Gary li]

But It's still the same error for using root username.

lark 写�：

Gary li wrote:

Hi,all
I am using Mysql 5.0 But I get an error message for calling procedure
with mysql_query().
My program is shown below:
Thank & Regard.
Gary.

#define W32_LEAN_AND_MEAN
#include <windows.h>
#include <mysql.h>
#include <stdio.h>
#include <string>

int main(int argc, char** argv)
{
MYSQL* sqlid = mysql_init(0);
if (!mysql_real_connect(sqlid, "localhost", "test", "test", "test", 0,
0, CLIENT_MULTI_STATEMENTS)) {
printf("%s\n", mysql_error(sqlid));
mysql_close(sqlid);
return -1;
}
sqlid->reconnect = 1;
std::string proc = "call pro_ins_department(10, 'test',
'testprocedure')";
if (0 != mysql_query(sqlid, proc.c_str())) {
printf("operator failed:%d %s\n", mysql_errno(sqlid),
mysql_error(sqlid));
} else {
MYSQL_RES * rs = mysql_store_result (sqlid);
MYSQL_ROW row = mysql_fetch_row(rs);
unsigned __int64 id = (unsigned __int64)atoi(row[0]);
printf("get id:id=%d\n", id);
}
mysql_close(sqlid);
return 0;
}

you have to make sure that you the username you're using has execute
privileges on that stored procedure in the database you're connecting
to. otherwise, it looks ok to me.