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?