PLS-00386: type mismatch found at 'string' between FETCH cursor and INTO variables

PLS-00386: type mismatch found at 'string' between FETCH cursor and INTO variables
Cause: An assignment target in the INTO list of a FETCH statement does not match in datatype with the corresponding column in the select list of the cursor declaration, and it is unclear which implicit conversion is required to correct the mismatch.
Action: Change the cursor declaration or change the datatype of the assignment target. You might want to use datatype conversion functions in the select list of the query associated with the cursor.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00386：在FETCH游标和INTO变量之间的' string '处找到类型不匹配,
.原因： FETCH语句的INTO列表中的分配目标在数据类型与游标声明的选择列表中的相应列不匹配，并且不清楚需要哪个隐式转换来纠正不匹配。,
.操作：更改游标声明或更改分配目标的数据类型。您可能希望在与光标相关联的查询的选择列表中使用数据类型转换函数。,
.

aiaiDBA

13718043309

010-86462881

PLS-00386: type mismatch found at 'string' between FETCH cursor and INTO variables

1 个回答

相似问题