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

NNO-00711: cache dump countdown aborted

1 Answers  


ORA-39124: dump file name "string" contains an invalid substitution variable

1 Answers  


DRG-12003: Please enter username for this FTP server:

1 Answers  


ORA-25132: UNIQUE constraint (string.string) disabled and validated in ALTER TABLE EXCHANGE PARTITION

1 Answers  


ORA-12318: database (link name string) is already mounted

1 Answers  






NNL-00961: Cache checkpoints: number

1 Answers  


LPX-00604: Invalid attribute value '~1S', for attribute '~2s'.

1 Answers  


ORA-19681: block media recovery on control file not possible

1 Answers  


LPX-00281: unsupported encoding "~s"

1 Answers  


ORA-06032: NETDNT: connect failed, access control data rejected

1 Answers  


ORA-31624: operation string not allowed when job in string state

1 Answers  


ORA-30338: illegal dimension hierachy name

1 Answers  


Categories