I am trying to spool output from a PL/SQL procedure to a local file with DBMS_OUTPUT.put_line.
After a few loops through a cursor, the following error arises:
ERROR at line 1:
ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes
ORA-06512: at line 52
SQL*Plus will not let me increase the screen buffer over 2000.
I've seen this remedied before but can't recall. Who knows the solution?