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-25141: invalid EXTENT MANAGEMENT clause

1 Answers  


ORA-00254: error in archive control string 'string'

1 Answers  


ORA-14001: LOCAL clause contradicts previosly specified GLOBAL clause

1 Answers  


NNO-00051: domain count number exceeds maximum of number, first number will be loaded

1 Answers  


RMAN-10007: error closing cursor

1 Answers  






ORA-01414: invalid array length when trying to bind array

1 Answers   Gucci,


QSM-02122: compatibility mode must be 8.1 or higher

1 Answers  


LSX-00002: root element is not <schema>

1 Answers  


SQL*Loader-00103: Invalid log file name on command line

1 Answers  


ORA-30371: column cannot define a level in more than one dimension

1 Answers  


ORA-15039: diskgroup not dropped

1 Answers  


CLSS-03000: reconfiguration successful, incarnation string with string nodes

1 Answers  


Categories