pro*c为什么执行EXEC SQL WHENEVER NOT FOUND GOTO FAIL1;报错谢谢!
错误如下:
"/app/gdian/GdianSrc/src/szgdian.c", line 2326.1: 1506-006 (S) Label FAIL1 is undefined.
"/app/gdian/GdianSrc/src/szgdian.c", line 2707.1: 1506-006 (S) Label FAIL1 is undefined.
"/app/gdian/GdianSrc/src/szgdian.c", line 3371.1: 1506-006 (S) Label FAIL1 is undefined.
"/app/gdian/GdianSrc/src/szgdian.c", line 3644.1: 1506-006 (S) Label FAIL1 is undefined.
make: 1254-004 The error code from the last command is 1.
错误如下:
"/app/gdian/GdianSrc/src/szgdian.c", line 2326.1: 1506-006 (S) Label FAIL1 is undefined.
"/app/gdian/GdianSrc/src/szgdian.c", line 2707.1: 1506-006 (S) Label FAIL1 is undefined.
"/app/gdian/GdianSrc/src/szgdian.c", line 3371.1: 1506-006 (S) Label FAIL1 is undefined.
"/app/gdian/GdianSrc/src/szgdian.c", line 3644.1: 1506-006 (S) Label FAIL1 is undefined.
make: 1254-004 The error code from the last command is 1.
EXEC SQL SELECT NAME, SALARY
INTO :name,:salary
FROM auths_yanyu
WHERE AUTHOR_CODE =:author_code1;错误提示:
INTO :NAME,:SALARY
........1
PCC-S-02322, found undefined identifier
Semantic error at line 71, column 15, file first1.pc:
INTO :NAME,:SALARY
..............1
PCC-S-02322, found undefined identifier
Semantic error at line 73, column 23, file first1.pc:
WHERE AUTHOR_CODE =:author_code1;
......................1
PCC-S-02322, found undefined identifier
有高手知道错在那里的请指教
EXEC SQL SELECT NAME, SALARY
INTO :name,:salary
FROM auths_yanyu
WHERE AUTHOR_CODE =:author_code1;中INTO :name,:salary 确认一下宿主变量 name,和salary 在.pc中定义过了没有 是不是和数据库里的类型匹配.