6 Replies Latest reply on Mar 28, 2018 3:42 PM by Robert Angel

    Buffer overflow while executing a PL/SQL procedure

    user3230252

      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