这个问题如何解决????
declare my_row all_objects%rowtype;
*
ERROR 位于第 1 行:
ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes
ORA-06512: 在"SYS.DBMS_OUTPUT", line 34
ORA-06512: 在"SYS.DBMS_OUTPUT", line 118
ORA-06512: 在"SYS.DBMS_OUTPUT", line 81
ORA-06512: 在line 9
我的程序如下
set serveroutput on;
declare my_row all_objects%rowtype;
cursor my_cursor is
select * from all_objects
where object_name like 'A%';
begin
open my_cursor;
loop
fetch my_cursor into my_row;
dbms_output.put_line(my_row.object_name);
exit when my_cursor%notfound;
end loop;
close my_cursor;
end;
/