Skip navigation

PL/SQL Compiler warning for implicit conversions

score 80
You have not voted. Active

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?

 

Regards,

Rop

Comments

Vote history