PLS-00620: type mismatch found at 'string' among operands in
a COALESCE expression



PLS-00620: type mismatch found at 'string' among operands in a COALESCE expression..

Answer / guest

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

Action: Change the operands so that their datatypes match.
Consider using datatype conversion functions in the operands.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-01187: cannot read from file string because it failed verification tests

1 Answers  


ORA-16041: Remote File Server fatal error

1 Answers  


ORA-13211: failed to tessellate the window object

1 Answers  


ORA-22337: the type of accessed object has been evolved

1 Answers  


ORA-31438: duplicate change table string

1 Answers  






ORA-30728: maximum number of columns exceeded

1 Answers  


ORA-26577: PRESERVE TABLE can not be used when dropping old style materialized view string.string

1 Answers  


ORA-30452: cannot compute AVG(X), VARIANCE(X) or STDDEV(X), without COUNT(X) or SUM(X)

1 Answers  


EXP-00029: Incremental export mode and consistent mode are not compatible

1 Answers  


TNS-00014: INTCTL: error while opening terminal input channel

1 Answers  


ORA-13024: polygon has less than three segments

1 Answers  


ORA-01724: floating point precision is out of range (1 to 126)

1 Answers  


Categories