- 论坛徽章:
- 0
|
本帖最后由 daydaycome 于 2011-07-12 15:46 编辑
proc 申明游标怎么会返回1403,游标申明不写sqlca.sqlcode??
int db_test1()
{
EXEC SQL BEGIN DECLARE SECTION;
char a[21];
EXEC SQL END DECLARE SECTION;
EXEC SQL select acc_no into :a from asd where acc_no='1';
printf("sqlcode before declare [%d]\n",sqlca.sqlcode);
EXEC SQL declare shop_cursor cursor for select shop_no from shop_arch
where mid = :sMid;
printf("sqlcode after declare [%d]\n",sqlca.sqlcode);
return 0;
}
结果:
main opendb
main db_test
sqlcode before declare [-942]
sqlcode after declare [-942]
main closedb |
|