Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-19029: Cannot convert the given XMLType to the required type

1 Answers  


DRG-12202: error while creating section group

1 Answers  


NNF-01005: Internal XOM class violation

1 Answers  


LSX-00204: extra data at end of complex element

1 Answers  


ORA-04098: trigger 'string.string' is invalid and failed re-validation

1 Answers  






TNS-01170: Event detection broke for address: string

1 Answers  


ORA-27088: unable to get file status

1 Answers  


LFI-00122: Can only delete a file if we create it.

1 Answers  


ORA-09341: scumnt: unable to mount database

1 Answers  


ORA-30115: error when processing an environment variable

1 Answers  


DGM-16948: Can not proceed to switchover. Primary is still "string".

1 Answers  


ORA-21705: service context is invalid

1 Answers  






Categories