Re: Usage dbms_output.enable

From: Ricardo Rocha <rrocha_at_usagate.net>
Date: 1997/03/05
Message-ID: <01bc2916$fcebc360$6464c7d0@rrocha>#1/1

Recall that

SET SERVEROUTPUT ON SIZE 100000 is a SQL*Plus (NOT a PL/SQL) command.

The "dbms_output" package does not actually perform any screen i/o; it just stores your lines in a buffer that may be later retrieved to display them.

When you specify "SET SERVEROUT ON...", SQL*Plus will retrieve the buffered lines and display them on the screen in an operation that is not related to the database.

Thus, a call to "dbms_output.enable" alone will not result in any lines being physically printer on the screen.

If you want to automate the setting of SERVEROUTPUT in your SQL*Plus sessions you could try including it in the local "login.sql" file (which is executed by SQL*Plus at startup). Received on Wed Mar 05 1997 - 00:00:00 CST