aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

PLS-00496: too few columns in SELECT...INTO statement after bursting record targets

PLS-00496: too few 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 columns to fill all of the fields in the record.
Action: Change the number of columns or the record variable(s) in the INTO clause so that they match.

请先 登录 后评论

1 个回答

小智
PLS-00496:SELECT ... INTO语句中突破记录目标后的列太少,
.原因:类型检查表明SELECT或FETCH中的列正在收集到INTO列表中的记录中。这个记录突然进入了它的领域。没有足够的列填充记录中的所有字段。,
.操作:更改INTO子句中的列数或记录变量,使其匹配。,
.
请先 登录 后评论