proc 申明游标怎么会返回1403
本帖最后由 daydaycome 于 2011-07-12 15:46 编辑proc 申明游标怎么会返回1403,游标申明不写sqlca.sqlcode??
int db_test1()
{
EXEC SQL BEGIN DECLARE SECTION;
char a;
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 没有做过PROC的开发。感觉代码怪怪的。 声明并不是执行,这时候sqlcode显示的并不是这个游标返回的内容
页:
[1]