dbms_output的应用

begin
     dbms_output.put_line('aa');
end;

 

 

set serveroutput on;

 
报  ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes问题的解决
方法1：set serveroutput on size 1000000

方法2：exec dbms_output.enable(999999999999999999999);