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

DRG-11870: Response From WAIS Server Too Large -- Extra Lines Ignored

1 Answers  


RMAN-08045: channel string: finished piece string at string with string copies

1 Answers  


ORA-30745: error occured while trying to add column "string" in table "string"

1 Answers  


ORA-09290: sksaalo: error allocating memory for archival

1 Answers  


ORA-27468: "string.string" is locked by another process

1 Answers  


ORA-16020: less destinations available than specified by LOG_ARCHIVE_MIN_SUCCEED_DEST

1 Answers  


DRG-10204: server update failed

1 Answers  


DRG-50928: reserved failure on line string on column string

1 Answers  


SQL*Loader-00604: Error occurred on an attempt to commit

1 Answers  


ORA-26096: transfer size too small for row data (number bytes required)

1 Answers  


ORA-28166: duplicate rolename in list

1 Answers  


ORA-32002: cannot create SPFILE already being used by the instance

1 Answers  


Categories