Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Limited "serveroutput" in a child report?

IckyIckyChiMoonMay 15 2015 — edited May 15 2015

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

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 12 2015
Added on May 15 2015
0 comments
325 views