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 either the CASE operand or WHEN operands.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/