4 Replies Latest reply on Oct 30, 2015 8:32 PM by rp0428

    Limit of 20K for DBMS_OUTPUT in child reports -- can it be increased?

    Brad Peek

      I have some SQL Developer child reports that use PL/SQL DBMS Output as the "Style".    However, I don't know how to increase the serveroutput limit beyond the 20K bytes that is currently the limit.

       

      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 line 21

       

      Is there a way to increase this limit for Child Reports?

       

      This question has been asked before, but I didn't see a response.