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

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

Oracle PL/SQL error message: ORA-20000: ORU-10027: buffer overflow, limit of 20000 bytes.

Cause:

The stored procedure ‘raise_application_error’ was called which causes this error to be generated.

Solution:

Check in procedure for all strings length.

Example:

declare
	v_first_name char(25000);
begin
	SELECT s.first_name into v_first_name 
	FROM students s WHERE s.CITY='New York';
	DBMS_OUTPUT.PUT_LINE('v_first_name: '||v_first_name);
end;

Output:

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

Correct:

declare
	v_first_name char(19986);
	--v_first_name varchar2(32000);
begin
	SELECT s.first_name into v_first_name 
	FROM students s WHERE s.CITY='New York';
	DBMS_OUTPUT.PUT_LINE('v_first_name: '||v_first_name);
end;

Output:

v_first_name: Daniel