The suggestion is based on this thread: How does Oracle evaluate this expression?
There was a serious bug in our code due to implicit conversion. It would be really helpful if the PL/SQL compiler could give a warning whenever it detects an implicit conversion.
In our case it was:
if INTERVAL > NUMBER then
Which seems to be converted to varchar2 with unexpected results.
if VARCHAR2 > VARCHAR2
Is it possible to have the compiler detect these cases and generate a warning?