Solved

SQL*Plus Buffer Overflow

Posted on 1998-05-15
1
1,251 Views
Last Modified: 2008-02-01
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?
0
Comment
Question by:Softchoice
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 3

Accepted Solution

by:
poncejua earned 50 total points
ID: 1081118
To increase buffer, use set serveroutput command:

  SET SERVEROUTPUT ON SIZE buffer_size

  For example:  SET SERVEROUTPUT ON SIZE 5000.

To verify the buffer size do SHOW SERVEROUTPUT.

For additional information on DBMS_OUTPUT refer to page 354 of ORACLE PL/SQL Programming.
0

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question