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