ORA-01861 Literal does not match Format string error..

Question

In the sql query's where clause I have a condition where where abc.item=NVL(P_ITEM,abc.item)

This is giving the ORA-01861 error.....

if the above condition is made to abc.item=NVL(P_ITEM,NULL) then the error does not raise... can I please know why the 1st condition is throwing an error... And How do I correct this...

Thanks Rashmi

Answer 1

My suspicion is that implicit casting is going on, where the data types of ABC.item and P_ITEM diverge. Can you provide a runnable test case?