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-13630: The task string contains execution results and cannot be executed.

1 Answers  


ORA-28043: invalid bind credentials for DB-OID connection

1 Answers  


ORA-16515: no rcv channel

1 Answers  


ORA-24142: invalid ruleset name

1 Answers  


ORA-28605: bitmap indexes cannot be reversed

1 Answers  






ORA-19007: Schema string does not match expected string.

1 Answers  


SQL*Loader-00470: table string does not have system generated OID

1 Answers  


DRG-12211: section or section id string does not exist

1 Answers  


ORA-23431: wrong state: string

1 Answers  


LFI-00110: Unable to initialize the Buffer Manager.

1 Answers  


O2I-00125: Error writing to the INITFILE file

1 Answers  


ORA-13626: The specified object string is not valid for task string.

1 Answers  


Categories