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-34722: (NLSCHARSET05) CAUTION: Character data loss in character set conversion from string to string

1 Answers  


PCB-00007: %s

1 Answers  


CLSR-01012: Invalid instance stop mode [string] is specified

1 Answers  


RMAN-08039: channel string: starting incremental datafile backupset restore

1 Answers  


ORA-24058: cannot downgrade QUEUE_TABLE that has propagation in a prepared state

1 Answers  


ORA-23454: flavor string not defined for object group "string"."string"

1 Answers  


ORA-01592: error converting Version 7 rollback segment (string) to Oracle 8 format

1 Answers  


PCC-00147: DBMS=V6 no longer supported; using DBMS=NATIVE

1 Answers  


RMAN-03009: failure of string command on string channel at string

1 Answers  


QSM-02035: no filter conditions are present in the HAVING clause

1 Answers  


RMAN-06068: recovery aborted because of missing datafiles

1 Answers  


ORA-24093: AQ agent string not granted privileges of database user string

1 Answers  


Categories