PLS-00645: character set mismatch found at 'string' among
operands in a COALESCE expression



PLS-00645: character set mismatch found at 'string' among operands in a COALESCE expressi..

Answer / guest

Cause: In a COALESCE expression, the operands do not match
in character set and it is unclear which implicit conversion
is required to correct the mismatch.

Action: Change the operands so that their character sets match.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

RMAN-08060: unable to find archive log

1 Answers  


ORA-30129: invalid function argument received

1 Answers  


ORA-30934: 'string' (string node) cannot be inserted in parent 'string' (string node)

1 Answers  


ORA-38307: object not in RECYCLE BIN

1 Answers  


ORA-02095: specified initialization parameter cannot be modified

1 Answers  






ORA-19714: length for generated name longer than string

1 Answers  


ORA-19960: Internal use only

1 Answers  


ORA-01799: a column may not be outer-joined to a subquery

1 Answers  


ORA-23332: group string is in use; cannot drop

1 Answers  


O2I-00128: Unable to write to the Java file

1 Answers  


ORA-12992: cannot drop parent key column

1 Answers  


ORA-02148: EXCLUSIVE specified multiple times

1 Answers  


Categories