Rounding of numeric values in Oracle queries


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

  • Screenshots:

Many thanks,