When connecting to a remote database, or a database in a different country over a network, the DBMS_Output window is slow to retrieve data, whereas in SQL*Plus it is much faster to retrieve the same information. Polling is set to 1 second.
For example, the following script:
=========================
declare
i pls_integer;
begin
for i in 1..300 loop
dbms_output.put_line('Line: '||i);
end loop;
end;
=========================
can take 20 seconds or more to return data in Toad, but is retrieved in SQL*Plus in 1 or 2 seconds.
SQL*Plus uses a different method to retrieve the DBMS_Output data and collects 15 lines at a time, rather than one line at a time.
WORKAROUND:
None.
STATUS:
Enhancement request ER 59078 has been submitted to Development for consideration in a future release of Toad for Oracle.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center