PLS-00620: type mismatch found at 'string' among operands in
a COALESCE expression
- 1 Answers
- 2449 Views
- I also Faced
- E-Mail Answers
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 |
ORA-02436: date or system variable wrongly specified in CHECK constraint
ORA-16062: DGID from standby not in Data Guard configuration
ORA-00264: no recovery required
LSX-00210: value "~1S" out of range for type "~2S"
NNL-00260: Server-generated requests now do not require authoritative answers
ORA-12092: cannot online redefine replicated table "string"."string"
ORA-25532: MTTR specified is too large: string
ORA-39042: invalid transform name string
ORA-12229: TNS:Interchange has no more free connections
PCC-01018: Conversion buffer size can only be specified for character types
ORA-27416: BYDAY= clause in repeat interval contains an invalid weekday
ORA-31111: table string cannot be hierarchically enabled
Oracle Errors 
