PLS-00616: type mismatch found at 'string' among result
expressions in a CASE expression



PLS-00616: type mismatch found at 'string' among result expressions in a CASE expression..

Answer / guest

Cause: In a CASE expression, the result expressions do not
match in datatype, and it is unclear which implicit
conversion is required to correct the mismatch.

Action: Change the result expressions so that their
datatypes match. Consider using datatype conversion
functions in the result expressions.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-01171: datafile string going offline due to error advancing checkpoint

1 Answers  


ORA-00312: online log string thread string: 'string'

1 Answers  


ORA-06042: NETDNT: message receive failure

1 Answers  


ORA-30039: Cannot drop the undo tablespace

1 Answers  


ORA-08179: concurrency check failed

1 Answers  






ORA-13002: specified level is out of range

1 Answers  


ORA-27476: "string.string" does not exist

1 Answers  


ORA-07441: function address must be aligned on string byte boundary

1 Answers  


ORA-38955: Source platform string not cross platform compliant

1 Answers  


ORA-28231: no data passed to obfuscation toolkit

1 Answers  


TNS-12668: Dedicated server: outbound protocol does not support proxies

1 Answers  


ORA-36638: (XSDUNION17) Concat dimension workspace object cannot be changed to UNIQUE because it has a non-unique concat base dimension workspace object.

1 Answers  


Categories