This discussion is archived
4 Replies Latest reply: Jul 14, 2008 11:26 AM by William Robertson RSS

DBMS_OUTPUT.ENABLE(null) - does this set the serveroutput size to unlimited

vaibhav468 Newbie
Currently Being Moderated
Hi,
I am in 10gR2. But my SQL plus client is still with 9i.
Hence i am unable to use the 10gR2 feature of setting the serveroutput to unlimited size.
If i issue
SET SERVEROUTPUT ON SIZE UNLIMITED

I am getting this error.
Usage: SET SERVEROUTPUT { ON | OFF } [SIZE n]
[ FOR[MAT] { WRA[PPED] | WOR[D_WRAPPED] | TRU[NCATED] } ]

This could be due to my 9i client.

My end goal is: all my dbms_output lines should get printed without getting buffer overflow error.

I know i can make use of dbms_output.enable - this also takes n as argument to set whatever be the buffer size.

Question: How can i use dbms_output.enable to set Unlimited size.