Not just the parameter count
vmatyi, September 05, 2024 - 7:27 am UTC
Thnak you for the answer!
I've played quite some with it before, and it's gets more complicated: adding a fourth, varchar2 parameter to the procedure doesn't change the outcome, and the loop executes without any problems on the range of 24000 to 35000 (vs. the posted 34000 to 45000), seemingly only "counting" numeric literals where the value itself is greater than 32768.
(I know, bugs can have a thousand faces, it's just seems to be an unusually peculiar one)
Thanks!
September 17, 2024 - 5:08 am UTC
It was well spotted by you... although I do need to question why you have a plsql block that is making thousands of calls :-)