ora-20000 oru-10027 buffer overflow

Problem:
------------

ora-20000 oru-10027 buffer overflow


Solution:
------------
There is two solutions:

1. If you are working in SQL*PLUS prompt, type the following where

SET SERVEROUTPUT ON SIZE n

where n is an integer between 2,000 and 1,000,000.

SQL> SET SERVEROUTPUT ON SIZE 10000


2. If you are working in PL/SQL block type

DBMS_OUTPUT.ENABLE(n)

where n is an integer between 2,000 and 1,000,000.

DBMS_OUTPUT.ENABLE(10000);