PLS-00597: expression 'string' in the INTO list is of wrong type

PLS-00597: expression 'string' in the INTO list is of wrong type
Cause: This exception is raised for the following errors:
- the expression in INTO clause of OPEN or RETURNING statement is neither of legal SQL datatypes nor of PL/SQL RECORD datatype

- a collection of records is used in INTO clause of OPEN or RETURNING statement.

- a record or a collection of records is used in BULK COLLECT INTO

Action: Use expression with correct datatype in the INTO clause

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00597：INTO列表中的表达式“ string ”的类型错误,
.原因：引发以下错误引发此异常：,
.- OPEN或RETURNING语句的INTO子句中的表达式既不是合法的SQL数据类型也不是PL / SQL RECORD数据类型,
.,
.- 在OPEN或RETURNING语句的INTO子句中使用记录集合。,
.,
.- 记录或记录集合用于BULK COLLECT INTO,
.,
.操作：在INTO子句中使用正确数据类型的表达式,
.

aiaiDBA

13718043309

010-86462881

PLS-00597: expression 'string' in the INTO list is of wrong type

1 个回答

相似问题