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.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center