4 Replies Latest reply on Jul 14, 2008 6:26 PM by William Robertson

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

    vaibhav468
      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.