PLS-00615

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

Causa: 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.

Acción: 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.