Oracle PLSQL buffer overflow error

Usually this error occurs when the total amount of text sent to DBMS_OUTPUT has exceeded the default limit of 20,000 bytes.

We can resolve this error by enabling the server output before executing PL/SQL objects.

SET SERVEROUTPUT ON SIZE UNLIMITED;