PLS-00400: different number of columns between cursor SELECT statement and return value

PLS-00400: different number of columns between cursor SELECT statement and return value
Cause: In a cursor declaration, a return type (such as RETURN emp%ROWTYPE) was specified, but the number of returned column values does not match the number of select-list items.
Action: Change the cursor return type or the select list so that the number of returned column values matches the number of select-list items.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00400：游标SELECT语句与返回值之间的列数不同,
.原因：在游标声明中，指定了返回类型（例如RETURN emp％ROWTYPE），但返回的列值的数量与选择列表项的数量不匹配。,
.操作：更改游标返回类型或选择列表，以使返回的列值与选择列表项数匹配。,
.

aiaiDBA

13718043309

010-86462881

PLS-00400: different number of columns between cursor SELECT statement and return value

1 个回答

相似问题