PLS-00615: type mismatch found at 'string' between CASE
operand and WHEN operands



PLS-00615: type mismatch found at 'string' between CASE operand and WHEN operands..

Answer / guest

Cause: In a simple CASE statement or expression, the CASE
operand and WHEN operands do not match in datatype, and it
is unclear which implicit conversion is required to correct
the mismatch.

Action: Change the CASE operand and WHEN operands so that
their datatypes match. Consider using datatype conversion
functions in the CASE operand and/or WHEN operands.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-00318: log string of thread string, expected file size string doesn't match string

1 Answers  


ORA-14272: only a partition with higher bound can be reused

1 Answers  


SQL*Loader-00268: UNRECOVERABLE keyword may be used only in direct path.

1 Answers  


ORA-15124: ASM file name 'string' contains an invalid alias name

1 Answers  


ORA-31151: Cyclic definition encountered for string: "string"

1 Answers   FBCH,






TNS-00551: underlying transport connection failed

1 Answers  


ORA-16543: invalid request made to broker

1 Answers  


ORA-22346: Type has cyclical dependency. Should use CASCADE option

1 Answers  


SQL*Loader-00290: PIECED keyword (on column string) allowed only for lob or long columns

1 Answers  


ORA-03233: unable to extend table string.string subpartition string by string in tablespace string

1 Answers  


ORA-32588: supplemental logging attribute string exists

1 Answers  


ORA-07478: scgcmn: cannot get lock status.

1 Answers  


Categories