TOAD returns an incorrect Record Count from the data grid of the SQL Editor Window when the "Set Schema" toolbar is used to point to a different schema. The data grid is populated correctly, but Record Count appears to be ignoring the Set Schema value and executes based solely on the connected user account.
For example, user A is connected and executes the following statement returning no values:
SELECT * from EMP;
User A then sets the schema to user B and executes the same query as above returning 14 records. Instead of displaying a Record Count of 14, TOAD displays zero (0) representing user A and not user B.
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