search

sijms / go-ora

Pure go oracle client
MIT License
786 stars 174 forks source link

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

Closed NPellet closed 1 year ago

NPellet commented 1 year ago

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 commented 1 year ago

please share example code to test

NPellet commented 1 year ago

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

rusco commented 1 year ago

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

sijms commented 1 year ago

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

NPellet commented 1 year ago

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 https://github.com/sijms/go-ora/issues/418#issuecomment-1692520572, or unsubscribe https://github.com/notifications/unsubscribe-auth/AALKLW3G532QF2MHUVFXX2TXW7MGTANCNFSM6AAAAAA3C6JODM . You are receiving this because you authored the thread.Message ID: @.***>