PLS-00615
type mismatch found at 'string' between CASE operand and WHEN operands
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.