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

PCB-00553: FOR clause not allowed on this statement

1 Answers  


ORA-07482: snlmini: cannot create lock manager instance.

1 Answers  


ORA-13914: Threshold notification failed.

1 Answers  


ORA-06917: CMX: error in data read (too many bytes read)

1 Answers  


ORA-29954: domain index partition is marked LOADING/FAILED/UNUSABLE

1 Answers  






TNS-01182: Listener rejected registration of service "string"

1 Answers  


ORA-31438: duplicate change table string

1 Answers  


PCC-02333: SQL identifier was not declared as a statement

1 Answers  


TNS-12648: Encryption or data integrity algorithm list empty

1 Answers  


ORA-15071: ASM disk "string" is already being dropped

1 Answers  


TNS-12549: TNS:operating system resource quota exceeded

1 Answers  


RMAN-08005: new incarnation of database registered in recovery catalog

1 Answers  


Categories