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-24339: cannot set server group name after connecting to server

1 Answers  


ORA-12666: Dedicated server: outbound transport protocol different from inbound

1 Answers  


PLS-00634: type with NOT INSTANTIABLE methods must be declared NOT INSTANTIABLE

1 Answers  


ORA-29551: could not convert string to Unicode

1 Answers  


NZE-29027: Error in entropy collection

1 Answers  


ORA-01546: tablespace contains active rollback segment 'string'

1 Answers  


LPX-00690: Invalid argument.

1 Answers  


TNS-04204: Trace Assistant Internal ERROR: Couldn't Open trace file

1 Answers  


ORA-22630: attribute [string] is null or it is not well-formed

1 Answers  


ORA-01315: Log file has been added or removed during select

1 Answers  


NCR-03005: NCRO: Orphan message

1 Answers  


NNO-00309: server restarting

1 Answers  


Categories