When I'm extracting data from Oracle I often have NUMERIC ID fields that I want to later use to trigger an API or other update.
However when I extract the data it appears that retool rounds it to 16 significant digits. When I change the query to convert the number to a character string I get the correct ID, but it's not ideal having to specify this in every query.
I don't see the same behaviour when using PostgreSQL only Oracle queries.
Is there any way to prevent this from happening?
Goal: Read a numeric ID from an Oracle table
Steps: Run an SQL query that returns an integer with more than 16 digits
Details: Numbers are rounded so end in 00 and then cannot be used in subsequent processes