proc 出现SELECT.INTO returns too many rows解决办法

proc 出现SELECT..INTO returns too many rows

 EXEC SQL BEGIN DECLARE SECTION;

  char CATYPE[20+1];
  char CAFEE[12];
  char CAPSINF[60+1];
  char CABILL[17];
  char CACHECK[8];

 EXEC SQL END DECLARE SECTION;
上面是定义的宿主变量

 EXEC SQL DECLARE TRAN_CURSOR CURSOR FOR SELECT BUSITYPE,CHECKFEE,PSINF,BILLDATES
  FROM TRANCHECKREPORT WHERE CHECKDATE=:CACHECK;
这个是cursor定义

 EXEC SQL SELECT BUSITYPE,CHECKFEE,PSINF,BILLDATES INTO:CATYPE,:CAFEE,:CAPSINF,:CABILL
  FROM TRANCHECKREPORT ;
这个是取数据语句
找不到上面原因。。。。

[解决办法]

C/C++ code

/* 声明游标 */EXEC SQL DECLARE TRAN_CURSOR CURSOR FOR SELECT BUSITYPE,CHECKFEE,PSINF,BILLDATES  FROM TRANCHECKREPORT WHERE CHECKDATE=:CACHECK;/* 打开游标 */EXEC SQL OPEN TRAN_CURSOR;/* 循环取数 */for (;;) {    EXEC SQL FETCH TRAN_CURSOR INTO :CATYPE,:CAFEE,:CAPSINF,:CABILL;    if (SQLCODE == 1403) {        /* 没有数据啦 */        break;    }}/* 关闭游标 */EXEC SQL CLOSE TRAN_CURSOR;