DBMS_OUTPUT questions

From: Code Monkee <monkee_at_monkeebusiness.com>
Date: Fri, 14 Feb 2003 16:46:17 -0600
Message-ID: <nVCdnQeRKIgy7NCjXTWc2Q_at_giganews.com>


Newbie questions:

  1. If I issue a "set serveroutput on" command from a sqlplus session does this enable DBMS_OUTPUT for the session only, or does it affect the entire DB?
  2. When I "set serveroutput on" I can see DBMS_OUTPUT for any PL/SQL procedures I invoke in sqlplus. How can I "set serveroutput on" for the entire DB, and where would I see the DBMS_OUTPUT?

Thanks. Received on Fri Feb 14 2003 - 23:46:17 CET

Original text of this message