Re: DBMS_OUTPUT questions

Code,

What version of Oracle, hardware, operating system version, etc.? Are you discussing Oracle 9i or Oracle release 5? There are many differences between the two.

My crystal ball says you are on a beta copy of Oracle 6.X and on a PC running MS-OS/2 version 2.1. Am I right?! Yup, thought so! See, my point is simple: We only know what you tell us, everything else is an assumption.

Back to your question, assuming I understand it and your situation correctly:

1. "set serveroutput on" enables DBMS_OUTPUT at the SQL*PLUS command level - not the database nor at the session level.
2. You need to reconsider the question, as "set serveroutput" doesn't deal with the database only with SQL*PLUS. Think about "What are you wanting to accomplish (instead of suggesting ways to accomplish it)?"

http://www.bmoshier.net/bertram

"Code Monkee" <monkee_at_monkeebusiness.com> wrote in message news: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 Sat Feb 15 2003 - 00:07:51 CET