Data is being limited to 3 numbers in size when the actual number is larger. (4253732)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Data is being limited to 3 numbers in size when the actual number is larger.
Description

Toad Data Point (TDP) seems to limit the number type size to 3 automatically.
Two examples:
1. When doing a records count for a table from an Oracle Local DB, TDP gave a result of 333, but actually it's 3331146.
2. Running a query displays 165 for one of the column data when it should be 1655.
SQL Developer shows the correct data.
Cause

Issue is due to using the Window Generic ODBC driver to connect to the Oracle Express Database.
Resolution

Switch from the Generic ODBC driver to the Oracle client connection to resolve the issue.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title