PLS-00618: type mismatch found at 'string' between operands
in a NULLIF expression



PLS-00618: type mismatch found at 'string' between operands in a NULLIF expression..

Answer / guest

Cause: In a NULLIF expression, the two 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

Post New Answer

More Oracle Errors Interview Questions

ORA-06916: CMX: error in data read (t_datain)

1 Answers  


ORA-29874: warning in the execution of ODCIINDEXALTER routine

1 Answers  


RMAN-06415: file string cannot be proxy backed up

1 Answers  


ORA-19675: file string was modified during proxy copy

1 Answers  


ORA-31054: The string operator cannot have an ancillary operator

1 Answers  


DRG-10307: no servers running

1 Answers  


SQL*Loader-00527: OCI return status: no data

1 Answers  


QSM-02010: join predicate with operator other than equals (=)

1 Answers  


ORA-12001: cannot create log: table 'string' already has a trigger

1 Answers  


ORA-27412: repeat interval contains invalid keyword: string

1 Answers  


TNS-12680: Native services disabled but required

1 Answers  


LCD-00112: illegal integer radix specification [string]

1 Answers  


Categories