Hello,
I've been trying to execute a procedure in Oracle 12c where was facing with below error in the console,
Msg ERROR: Msg Error (SQL) 20000: OCI_ERROR: ORA-20000: ORU-10027: buffer overflow, limit of 20000 bytes
ORA-06512: at "SYS.DBMS_OUTPUT", line 32
ORA-06512: at "SYS.DBMS_OUTPUT", line 97
ORA-06512: at "SYS.DBMS_OUTPUT", line 112
ORA-06512: at "AAAMAINDB.GEN_IMPORT_UD_FIELD", line 99
ORA-06512: at line 2
The procedure comprises of a DBMS.OUTPUT as such below,
==============
v_output_str := 'UD_FIELDS ' || v_xa_sqlname_c || ';' || v_xe_sqlname_c || ';' || v_xa_name || ';' || v_dd_sqlname_c || ';1;' || v_xa_mandatory_f || ';' || v_xa_default_c || ';' || v_xa_perm_val_f || ';' || v_xa_calculated_e || ';' || v_xa_widget_e || ';' || v_ref_xe_sqlname_c || ';' || v_xa_perm_auth_e || ';' || v_xa_subtype_mask || ';' || v_xa_quick_search_mask || ';' || v_xa_search_mask || ';' || v_xa_max_db_len_n || ';' || v_xa_default_display_len_n || ';' || v_xa_edit_e || ';' || v_xa_par_sqlname_c || ';' || v_xe_par_sqlname_c || ';1;';
DBMS_OUTPUT.put_line(v_output_str);
==============
Is there any specific setting which can be applied to increase the buffer size of the database. Since setting the parameter "SET SERVEROUTPUT ON SIZE UNLIMITED" in glogin,sql does not resolve the issue.
Despite of altering the PL/SQL procedure "AAAMAINDB.GEN_IMPORT_UD_FIELD" to add the parameter "DBMS_OUTPUT.ENABLE(1000000);". Is there any other configuration which can be performed to explicitly increase buffer size in the database ? Please help me out.
Thanks,
Dilip Kumar S