pro*c 里怎么将select 的返回内容赋值给变量那?
EXEC SQL BEGIN DECLARE SECTION;
char CALLNO[30];
EXEC SQL END DECLARE SECTION;
EXEC SQL SELECT CALLNO INTO :CALLNO FROM out_call;
EXEC SQL COMMIT WORK RELEASE;
printf("CALLNO = %s\n intCALLNO = %d\n",CALLNO,intCALLNO);
打印结果为空
EXEC SQL BEGIN DECLARE SECTION;
char CALLNO[30];
EXEC SQL END DECLARE SECTION;
EXEC SQL SELECT CALLNO INTO :CALLNO FROM out_call;
EXEC SQL COMMIT WORK RELEASE;
printf("CALLNO = %s\n intCALLNO = %d\n",CALLNO,intCALLNO);
打印结果为空
begin
select v_value into :var_temp from you_table;
end;
print var_temp;--显示var_temp的值
另外,可能你查询出来的数据不止一条,也会出问题的……