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-02854: Invalid number of request buffers

1 Answers  


ORA-39727: COMPATIBLE must be set to 10.0.0.0.0 or higher

1 Answers  


LFI-00117: Unable to rename file.

1 Answers  


ORA-06018: NETASY: message send failure

1 Answers  


NZE-29141: Cannot import in the der format.

1 Answers  






O2I-00112: Unable to write to the HFILE file

1 Answers  


ORA-08205: ora_addr: $ORACLE_SID not set in environment

1 Answers  


ORA-06749: TLI Driver: option not allowed across network

1 Answers  


ORA-38029: object statistics are locked

1 Answers  


ALTER TABLE JAFAR_BIZREN_REDUMPTION_DATA1 RENAME COLUMN DROP_POINT TO DEPOT_ID

0 Answers   Oracle,


TNS-00259: Disabled Interchange list:

1 Answers  


ORA-19585: premature end of volume on piece string

1 Answers  


Categories