This content has been marked as final. Show 4 replies
dbms_output.enable(null) will default to 20000 for backwards compatibility. See docs: http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_output.htm#i999293
I don't see where it says that a null argument to DBMS_OUTPUT.ENABLE will be treated as 20000. It seems to work fine for me (SQL*Plus and DBMS 11.1).
Message was edited by:
Oops - left a zero off "20000".
I don't see where it says that a null argument to DBMS_OUTPUT.ENABLE will be treated as 2000 (20000?).Look at the Usage Notes in the link oradev060708 provided.
NULL is expected to be the usual choice. The default is 20,000 for backwards compatibility with earlier database versions that did not support unlimited buffering.
That doesn't treat a null argument as 20000, it defaults a value of 20000 when no value is passed. I don't have a pre-10g client to test with but I would be surprised if DBMS_OUTPUT.ENABLE(NULL) doesn't have the same effect as it does in recent versions.