Link to home
Start Free TrialLog in
Avatar of Softchoice
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?
ASKER CERTIFIED SOLUTION
Avatar of poncejua
poncejua

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial