Tuesday, June 11, 2019

Nice bug in Oracle 12.2.0.1 affecting function NUMTODSINTERVAL

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.

select numtodsinterval(11505,'SECONDS') from dual;

This simple query killed my sqldeveloper session.
I mistakenly wrote SECONDS instead of SECOND and boom!

I ignore if the same happens with the plurals of the other units.

I wonder what kind of parameter checking is done in this function...

No comments:

yes you can!

Two great ways to help us out with a minimal effort. Click on the Google Plus +1 button above or...
We appreciate your support!

latest articles