PLS-00401: different column types between cursor SELECT statement and return value found at 'string'

PLS-00401: different column types between cursor SELECT statement and return value found at 'string'
Cause: In a cursor declaration, a return type (such as RETURN emp%ROWTYPE) was specified, but a returned column value and its corresponding select-list item have different datatypes.
Action: Change the cursor return type or the select list so that each returned column value and its corresponding select-list item have the same datatype.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00401：游标SELECT语句和返回值之间的不同列类型在' string ',
.原因：在游标声明中，指定了返回类型（例如RETURN emp％ROWTYPE），但返回的列值及其相应的选择列表项具有不同的数据类型。,
.操作：更改游标返回类型或选择列表，使每个返回的列值及其相应的选择列表项具有相同的数据类型。,
.

aiaiDBA

13718043309

010-86462881

PLS-00401: different column types between cursor SELECT statement and return value found at 'string'

1 个回答

相似问题