PLS-00495: too many columns in SELECT...INTO statement after bursting record targets

PLS-00495: too many columns in SELECT...INTO statement after bursting record targets
Cause: Type checking indicated the columns in a SELECT or FETCH were being collected into a record in the INTO list. The record was burst into its fields. There were not enough fields in the record for each of the columns.
Action: Change the number of columns or the record variable(s) in the INTO clause so that they match.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00495：SELECT ... INTO语句中的列太多，突破记录目标,
.原因：类型检查表明SELECT或FETCH中的列正在收集到INTO列表中的记录中。这个记录突然进入了它的领域。每个列的记录中没有足够的字段。,
.操作：更改INTO子句中的列数或记录变量，使其匹配。,
.

aiaiDBA

13718043309

010-86462881

PLS-00495: too many columns in SELECT...INTO statement after bursting record targets

1 个回答

相似问题