PLS-00616: type mismatch found at 'string' among result expressions in a CASE expression

PLS-00616: type mismatch found at 'string' among result expressions in a CASE expression
Cause: In a CASE expression, the result expressions do not match in datatype, and it is unclear which implicit conversion is required to correct the mismatch.
Action: Change the result expressions so that their datatypes match. Consider using datatype conversion functions in the result expressions.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS- 00616：CASE表达式的结果表达式中' string ' 处找到类型不匹配,
.原因：在CASE表达式中，结果表达式在数据类型中不匹配，并且不清楚需要哪个隐式转换来纠正不匹配。,
.操作：更改结果表达式，使其数据类型匹配。考虑在结果表达式中使用数据类型转换函数。,
.

aiaiDBA

13718043309

010-86462881

PLS-00616: type mismatch found at 'string' among result expressions in a CASE expression

1 个回答

相似问题