Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dbms_output.enable(buffer_size => NULL)

jchristianApr 1 2013 — edited Apr 1 2013
Hi,

I am reviewing the document PL/SQL Packages and Types Reference
11g Release 1 (11.1.)
B28419-03

There is a section that indicates:
...
Typing SET SERVEROUTPUT ON in SQL*Plus has the effect of invoking
DBMS_OUTPUT.ENABLE (buffer_size => NULL);
with no limit on the output.
...

When I test using an anonymous block, using buffer_size of NULL doesn't produce any output.
set serveroutput on

begin
dbms_output.put_line('Foo');
end;
/
Produces output as expected.
begin
dbms_output.enable(buffer_size => NULL);
dbms_output.put_line('Foo');
end;
/
Produces no output.

This is not what I had expected. Can anyone explain what I am doing incorrectly?
This post has been answered by Solomon Yakobson on Apr 1 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 29 2013
Added on Apr 1 2013
7 comments
9,851 views