Ora-20000:oru-10027:buffer Overflow,limit of 10000 bytes solution

Today, when developing a stored procedure, when executing a dbms_output.putline (variable), the report

ora-20000:oru-10027:buffer Overflow,limit of 10000 bytes.

As shown in the following illustration:

problem Reason: The buffer is 10,000 bits and the printed character exceeds the limit.

Workaround 1 Increase Buffer

Sql>set serveroutput on size 1000000

Workaround 2 Set buffer unrestricted

Add Dbms_output after the begin. ENABLE (buffer_size => null) to indicate that the output buffer is unrestricted.