0 Replies Latest reply on May 15, 2015 7:31 PM by IckyIckyChiMoon

    Limited "serveroutput" in a child report?

    IckyIckyChiMoon

      Using SQL-Dev 4.1

       

      When I "SET serveroutput ON" in a normal worksheet/connection, I can get quite a bit of output from a pl-sql block (I think the limit is 1,000,000).

      But when I take the same pl-sql block and put it in a child-report of a user-defined-report, it seems to limit the output to 20,000.

       

      I get this error:

      An error was encountered performing the requested operation:

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

      ORA-06512: at "SYS.DBMS_OUTPUT", line 32

       

      Does anyone know where I could find the setting to increase this to the normal 1m?

       

      Thanks,

      iicm