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

NZE-28816: No password provided for a PL/SQL function.

1 Answers  


ORA-39315: illegal swap() call: only applys after clone/sync_code

1 Answers  


TNS-00202: Failure in redirecting call : Original to string Redirect to string

1 Answers  


ORA-24308: illegal define position

1 Answers  


RMAN-06022: invalid level specified for image copy: number

1 Answers  






NNO-00633: detected fatal delegation loop involving server "string"

1 Answers  


ORA-30938: No prefix defined for namespace 'string' (particle string)

1 Answers  


PLS-00904: insufficient privilege to access object string

1 Answers  


ORA-14044: only one partition may be moved

1 Answers  


ORA-06322: IPA: Fatal shared memory error

1 Answers  


ORA-26089: LONG column "string" must be specified last

1 Answers  


ORA-01193: file string is not the same file seen at start of recovery

1 Answers  


Categories