SqlDbx
You are not logged in.
Pages: 1
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
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
Great! Thanks.
Pietro
Offline
Pages: 1