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_ME AN
#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_co nnect(sqlid, "localhost" , "test", "test", "test", 0,
0, CLIENT_MULTI_ST ATEMENTS)) {
printf("%s\n", mysql_error(sql id));
mysql_close(sql id);
return -1;
}
sqlid->reconnect = 1;
std::string proc = "call pro_ins_departm ent(10, 'test',
'testprocedure' )";
if (0 != mysql_query(sql id, proc.c_str())) {
printf("operato r failed:%d %s\n", mysql_errno(sql id),
mysql_error(sql id));
} else {
MYSQL_RES * rs = mysql_store_res ult (sqlid);
MYSQL_ROW row = mysql_fetch_row (rs);
unsigned __int64 id = (unsigned __int64)atoi(ro w[0]);
printf("get id:id=%d\n", id);
}
mysql_close(sql id);
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_ME AN
#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_co nnect(sqlid, "localhost" , "test", "test", "test", 0,
0, CLIENT_MULTI_ST ATEMENTS)) {
printf("%s\n", mysql_error(sql id));
mysql_close(sql id);
return -1;
}
sqlid->reconnect = 1;
std::string proc = "call pro_ins_departm ent(10, 'test',
'testprocedure' )";
if (0 != mysql_query(sql id, proc.c_str())) {
printf("operato r failed:%d %s\n", mysql_errno(sql id),
mysql_error(sql id));
} else {
MYSQL_RES * rs = mysql_store_res ult (sqlid);
MYSQL_ROW row = mysql_fetch_row (rs);
unsigned __int64 id = (unsigned __int64)atoi(ro w[0]);
printf("get id:id=%d\n", id);
}
mysql_close(sql id);
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_ME AN
#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_co nnect(sqlid, "localhost" , "test", "test", "test", 0,
0, CLIENT_MULTI_ST ATEMENTS)) {
printf("%s\n", mysql_error(sql id));
mysql_close(sql id);
return -1;
}
sqlid->reconnect = 1;
std::string proc = "call pro_ins_departm ent(10, 'test',
'testprocedure' )";
if (0 != mysql_query(sql id, proc.c_str())) {
printf("operato r failed:%d %s\n", mysql_errno(sql id),
mysql_error(sql id));
} else {
MYSQL_RES * rs = mysql_store_res ult (sqlid);
MYSQL_ROW row = mysql_fetch_row (rs);
unsigned __int64 id = (unsigned __int64)atoi(ro w[0]);
printf("get id:id=%d\n", id);
}
mysql_close(sql id);
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.