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

RMAN-08585: copying standby controlfile

1 Answers  


ORA-34896: (PPMONTHS00) At least 12 month names must be given. Only number were provided.

1 Answers  


ORA-14258: invalid partition description

1 Answers  


ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine

1 Answers  


QSM-02047: window function in mv

1 Answers  






ORA-01679: database must be mounted EXCLUSIVE and not open to activate

1 Answers  


ORA-39019: invalid operation type string

1 Answers  


ORA-30103: 'string' contains an illegal integer radix for 'string'

1 Answers  


ORA-12611: TNS:operation is not portable

1 Answers  


NCR-03026: NCRO: The result buffer has overflowed

1 Answers  


TNS-00297: Logging Level : string

1 Answers  


TNS-12160: TNS:internal error: Bad error number

1 Answers  


Categories