Softchoice
asked on
SQL*Plus Buffer Overflow
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.