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-02490: missing required file size in RESIZE clause

1 Answers  


ORA-00309: log belongs to wrong database

1 Answers  


ORA-16806: Supplemental logging is not turned on.

1 Answers  


ORA-40002: wordsize must be string or greater

1 Answers  


ORA-12660: Encryption or crypto-checksumming parameters incompatible

1 Answers  






ORA-39096: invalid input value string for parameter string

1 Answers  


ORA-28515: cannot get external object definitions from string

1 Answers  


ORA-09758: osnipn: could not check port in name server.

1 Answers  


ORA-08452: specification of E in picture mask is unsupported

1 Answers  


ORA-31512: name cannot contain double quotation marks

1 Answers  


LPX-00285: invalid Unicode surrogate ~X ~X

1 Answers  


LSX-00259: invalid character found in the pattern

1 Answers  


Categories