使用EXEC SQL PREPARE出错!
EXEC SQL BEGIN DECLARE SECTION;
char strSql[1000];
EXEC SQL END DECLARE SECTION;
strcpy(strSql,"SELECT sa_ins_id FROM tbl_ins_inf_new WHERE sa_ins_id='1100060020001'");
memset(H_username,0,sizeof(H_username));
memset(H_password,0,sizeof(H_password));
strcpy(H_username,"sa");
EXEC SQL CONNECT :H_username IDENTIFIED BY :H_password ;
if (sqlca.sqlcode!=0)
{
printf("Error occur!");
return -1;
}
EXEC SQL USE toplink;
if (sqlca.sqlcode!=0)
{
printf("Use toplink error!");
return -2;
}
printf("The sql is: %s\n",strSql);
EXEC SQL PREPARE select_opr1 FROM :strSql;
if (sqlca.sqlcode!=0) 这里出错:sqlca.sqlcode返回-193.
{
printf("SQL Prepare Error!\n");
printf("Error code is:%d\n",sqlca.sqlcode);
exit(-1);
}
请问是什么问题?