- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 73 Insurance
- 537.3K On-Premises Infrastructure
- 138.6K Analytics Software
- 38.6K Application Development Software
- 6K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
PL/SQL Compiler warning for implicit conversions
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?