Thursday, November 20, 2008

Set serveroutput on

SET SERVEROUTPUT ON in SQL*Plus is equivalent to:
dbms_output.enable(buffer_size => NULL);

dbms_output.enable(buffer_size IN INTEGER DEFAULT 20000);
exec dbms_output.enable(1000000);

dbms_output.disable;
exec dbms_output.disable;

No comments: