PLS-00497: cannot mix between single row and multi-row (BULK) in INTO list

PLS-00497: cannot mix between single row and multi-row (BULK) in INTO list
Cause: - When BULK syntax (e.g. BULK COLLECT INTO) is used to retrieve data, every variable in the INTO list has to be of type that is a collection of the type of the corresponding column.
- When BULK is NOT used, every variable in the INTO list has to be of compatible type with the corresponding column.

Action: Change the INTO list so that all variables have correct data types

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00497：不能在INTO列表中的单行和多行（BULK）之间进行混合,
.原因： - 当使用BULK语法（例如BULK COLLECT INTO）检索数据时，INTO列表中的每个变量都必须是相应列类型的集合。,
.- 当不使用BULK时，INTO列表中的每个变量必须与相应的列兼容。,
.,
.操作：更改INTO列表，使所有变量都具有正确的数据类型,
.

aiaiDBA

13718043309

010-86462881

PLS-00497: cannot mix between single row and multi-row (BULK) in INTO list

1 个回答

相似问题