PLS-00499: coercion into collection of records not supported

PLS-00499: coercion into collection of records not supported
Cause: A SELECT or FETCH may specify a column list to be coerced into a variable which is a collection of records. This is type checked as correct, but not yet supported because of the implicit layout change required.
Action: Express the SELECT with an object constructor around the columns and use a collection of objects as an INTO variable. Or, build the collection one row at a time coercing each row into a record which happens to be an element. Or, use a record of collections.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00499：强制进入不支持的记录集合,
.原因： SELECT或FETCH可以指定要强制列入作为记录集合的变量的列列表。这是类型检查正确，但由于需要隐式的布局更改，尚未支持。,
.操作：使用列的对象构造函数来表达SELECT，并使用一组对象作为INTO变量。或者，一次将该集合建立一行，将每一行强制为一个恰好是一个元素的记录。或者，使用收藏记录。,
.

aiaiDBA

13718043309

010-86462881

PLS-00499: coercion into collection of records not supported

1 个回答

相似问题