buffer overlfow while running the plsql blocks in oracle database (ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes)

ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes

add below statement under your 'begin' block and also under the 'exception' block.

DBMS_OUTPUT.ENABLE(1000000);       -- Clear DBMS_OUTPUT buffer.

Example:

declare

.<test variables>

begin

DBMS_OUTPUT.ENABLE(1000000);       -- Clear DBMS_OUTPUT buffer.

--

-- <logic>

exception

when others then <do something>;

DBMS_OUTPUT.ENABLE(1000000);       -- Clear DBMS_OUTPUT buffer.

end;