DBMS_OUTPUT.ENABLE(null) - does this set the serveroutput size to unlimited
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.