PLS-00394: 在 FETCH 语句的 INTO 列表中值数量出现错误
0
悬赏园豆：20
[已关闭问题]
关闭于 2019-01-14 13:34
在行: 154 上开始执行命令时出错 -
DECLARE
CURSOR CURMY IS SELECT LOANAPPLID , APPFLWCODE FROM APLOAN;
V_A APLOAN%ROWTYPE;
BEGIN
OPEN CURMY;
LOOP
FETCH CURMY INTO V_A;
UPDATE LNBPA SET BPCONO = V_A.APPFLWCODE WHERE
BPA_ID = V_A.LOANAPPLID;
EXIT WHEN CURMY%NOTFOUND;
END LOOP;
CLOSE CURMY;
END;
错误报告 -
ORA-06550: 第 7 行, 第 5 列:
PLS-00394: 在 FETCH 语句的 INTO 列表中值数量出现错误
ORA-06550: 第 7 行, 第 5 列:
PL/SQL: SQL Statement ignored
- 00000 - "line %s, column %s:\n%s"
Cause: Usually a PL/SQL compilation error.
Action:
