Scrolling through a record set in the SQL Editor data grid reports incorrect row counts, misreporting the current number of fetched rows as being the total number of rows. The incorrect row count is a result of the View | Options | Oracle | General | "OCI Array Buffer size" setting. For example, assume that this option is set to 2500 and the number of rows returned is 10000.
After scrolling through the first 2500 records, TOAD will display a result of 5000. After scrolling through 5000 records, TOAD will display a count of 7500 and so on using increments of the OCI Array Buffer setting.
In addition, if the total number of rows is less than the OCI buffer size, the total row count is not displayed at all in the bottom left hand corner of the data grid.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center