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

ORA-31664: unable to construct unique job name when defaulted

1 Answers  


ORA-12319: database (link name string) is already open

1 Answers  


ORA-39307: the operation is illegal without an initial clone

1 Answers  


ORA-31492: could not set session parameters for LogMiner session

1 Answers  


ORA-29849: error occurred in the execution of ODCIINDEXSPLITPARTITION routine

1 Answers  






LPX-00324: "~S" is not a valid value for the lang attribute of xsl:sort

1 Answers  


ORA-07324: smpall: malloc error while allocating pga.

1 Answers  


DRG-10533: invalid user name: string

1 Answers  


ORA-09812: Unable to get user clearance from connection

1 Answers  


ORA-04095: trigger 'string' already exists on another table, cannot replace it

1 Answers  


ORA-24193: the property value exceeds the valid range string

1 Answers  


RMAN-08010: channel string: specifying datafile(s) in backupset

1 Answers  


Categories