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-02432: cannot enable primary key - primary key not defined for table

1 Answers  


ORA-26665: STREAMS process string already exists

1 Answers  


RMAN-20206: log sequence not found in the repository

1 Answers  


ORA-06262: NETNTT: nfconn() failed

1 Answers  


ORA-04002: INCREMENT must be a non-zero integer

1 Answers  






ORA-30490: Ambiguous expression in GROUP BY ROLLUP or CUBE list

1 Answers  


TNS-00284: Imm Max Avg Bytes/Sec : number

1 Answers  


ORA-01237: cannot extend datafile string

2 Answers  


ORA-36956: (XSFCAST25) There are only number PERIODICITY values. You cannot specify more OFFSET values.

1 Answers  


ORA-22314: method information mismatch in ALTER TYPE

1 Answers  


ORA-26090: row is in partial state

1 Answers  


RMAN-08503: piece handle=string comment=string

1 Answers  


Categories