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-36710: (XSMXALLOC01) TARGETLOG variable workspace object must be dimensioned identically to TARGET variable workspace object.

1 Answers  


ORA-21525: attribute number or (collection element at index) string violated its constraints

1 Answers  


ORA-39064: unable to write to the log file

1 Answers  


ORA-06929: CMX: error when sending ORACLE_SID

1 Answers  


LSX-00294: field "~S" produced multiple hits

1 Answers  


ORA-13864: Statistics aggregation for service (module/action) string is already enabled

1 Answers  


ORA-09796: szrbuild: malloc of role name failed.

1 Answers  


QSM-00772: the specified SQL statement cannot be stored in the workload due to a statement error

1 Answers  


DRG-11806: Non-authoritative Information

1 Answers  


ORA-23494: too many rows for destination "string"

1 Answers  


ORA-09982: skxfqddrg: Error Removing a page from the SDI buffer pool

1 Answers  


RMAN-08161: contents of Memory Script:

1 Answers  


Categories