Querying fields of type NUMBER(20,0) causes ORA-03120

[NPellet]

We are storing pretty large numbers, yet still in the 64bit range.
When performing a SELECT them over them (they are stored in a NUMBER(20,0) field) we get

ORA-03120: two-task conversion routine: integer overflow

We're currently debugging it to try to give more information, but we thought you should know and maybe have an idea.

[sijms]

please share example code to test

[NPellet]

Yeah we're working on it.
Seems to be platform dependent, though. Will update ASAP

[rusco]

Enclose this column with ROUND(...) is a workaround I use for this issue

[sijms]

last version v2.7.16 fix some number decoding please try again and see if issue fixed

[NPellet]

Sorry got side tracked on this. I'll try

…

On Fri, 25 Aug 2023, 00:59 Samy Sultan, ***@***.***> wrote: last version v2.7.16 fix some number decoding please try again and see if issue fixed — Reply to this email directly, view it on GitHub <#418 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AALKLW3G532QF2MHUVFXX2TXW7MGTANCNFSM6AAAAAA3C6JODM> . You are receiving this because you authored the thread.Message ID: ***@***.***>