SqlDbx Forum

SqlDbx

You are not logged in.

#1 2014-06-04 14:32:43

ptoniolo
Member

dbms_output buffer size

What is the size of the buffer that sqldbx uses for dbms_output-generated messages? I need a very large buffer, because I often use this buffer as a debugging aid, but I believe that the size used by sqldbx is some 1000 characters only.

Is there a way to specify the buffer size, as in the SQL*Plus command:
    SET SERVEROUTPUT ON SIZE xxxx
???

A parameter in the Oracle settings would be highly appreciated!
p

Offline

#2 2014-06-04 20:06:11

sqldbxhelp
Administrator

Re: dbms_output buffer size

SqlDbx does not explicitly set DBMS_OUTPUT package buffer size.
The only limit we have is 1k line length.
Do you get error about truncation?
If not then you can set buffer size by executing following:

BEGIN
SYS.DBMS_OUTPUT.ENABLE (100000);
END;

You can put the above in Startup Script edit box in Oracle options to make it permanent.

Offline

#3 2014-06-05 04:35:14

ptoniolo
Member

Re: dbms_output buffer size

Great! Thanks.
Pietro

Offline

Board footer

Powered by FluxBB