Proc编译Fetch into 第三列覆盖第二列,该如何解决

Proc编译Fetch into 第三列覆盖第二列

C/C++ code

/* allocate cursor variable */     EXEC SQL ALLOCATE :cursor;     /* call the stored procedure */    EXEC SQL EXECUTE     BEGIN         proc(:cursor);     END;     END-EXEC;    for(;;)    {        EXEC SQL WHENEVER NOT FOUND DO break;         EXEC SQL FETCH :cursor             INTO :ename, :job, :empno;                      printf("%s    %s    ", ename, job);         printf("%s\n", empno);    }    EXEC SQL CLOSE :cursor;    EXEC SQL FREE :cursor;    EXEC SQL COMMIT WORK RELEASE;    return 0;-----------Connecting to impgw/impgw@ORCL ......Connect to impgw/impgw@ORCL OK111     18      8111     18      8请按任意键继续. . .----------------SQL> select * from test; A                    B                    C-------------------- -------------------- --------------------111                  123456               8111                  123456               8111                  123456               8