PLS-00615: type mismatch found at 'string' between CASE operand and WHEN operands

PLS-00615: type mismatch found at 'string' between CASE operand and WHEN operands
Cause: In a simple CASE statement or expression, the CASE operand and WHEN operands do not match in datatype, and it is unclear which implicit conversion is required to correct the mismatch.
Action: Change the CASE operand and WHEN operands so that their datatypes match. Consider using datatype conversion functions in the CASE operand and/or WHEN operands.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00615：CASE操作数和WHEN操作数之间的“ string ” 发现类型不匹配,
.原因：在一个简单的CASE语句或表达式中，CASE操作数和WHEN操作数在数据类型中不匹配，并且不清楚需要哪个隐式转换来纠正不匹配。,
.操作：更改CASE操作数和WHEN操作数，使其数据类型匹配。考虑在CASE操作数和/或WHEN操作数中使用数据类型转换功能。,
.

aiaiDBA

13718043309

010-86462881

PLS-00615: type mismatch found at 'string' between CASE operand and WHEN operands

1 个回答

相似问题