In SQL Developer if you exeed maximum bytes for buffer - you get nice information
Error report -
ORA-20000: ORU-10027: buffer overflow, limit of 1000000 bytes
ORA-06512: at "SYS.DBMS_OUTPUT", line 32
ORA-06512: at "SYS.DBMS_OUTPUT", line 97
ORA-06512: at "SYS.DBMS_OUTPUT", line 112
ORA-06512: at line 7
ORA-06512: at line 7
and script stop
On the other hand, VS Code tries to display everything in the output, and there's no straightforward way to stop it. There are no tasks in the Task Monitor, and you can't cancel the SQL query because it has already finished. Is there (or will there be) a way to stop such "accidental" output streaming?
Example (run at your own risk)
==============================================
set serveroutput on
begin
for z in (with data as (
select level lvl
from dual connect by level <= 5000)
select *
from employees, data )loop
dbms_output.put_line(z.last_name);
end loop;
end;
/
============================================