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

LFI-00128: Carriage Control is only valid for Standard file objects.

1 Answers  


LPX-00406: object of incorrect type passed to the function

1 Answers  


ORA-02381: cannot drop PUBLIC_DEFAULT profile

1 Answers  


SQL*Loader-00628: Character set conversion error.

1 Answers  


ORA-23456: flavor string does not contain "string"

1 Answers  






RMAN-06221: Removing automatic instance

1 Answers  


ORA-24905: invalid recepient protocol attribute passed into OCI call

1 Answers  


RMAN-06090: error while looking up controlfile copy: string

1 Answers  


ORA-12994: drop column option only allowed once in statement

1 Answers  


ORA-23542: dependent object "string"."string" already registered

1 Answers  


ORA-19551: device is busy, device type: string, device name: string

1 Answers  


PLS-00726: MODIFY ELEMENT is supported only on schema-level varray and nested tables

1 Answers  


Categories