Re: DBMS_OUTPUT questions

From: Code Monkee <monkee_at_monkeebusiness.com>
Date: Fri, 14 Feb 2003 17:44:59 -0600
Message-ID: <3dWdnVmjDsrs4tCjXTWc3w_at_giganews.com>


I stand corrected! Us newbies are a sorry lot indeed.

How can I view the debug info generated by DBMS_OUTPUT statements that are part of Oracle 8i PL/SQL stored procedures that are executing on a Dell Server with dual 550 Mhz processors and 4GB of memory, running MS Windows 2000 Server version 5.0.2195 Service Pack 2 Build 2195?

Also, where can I find more detailed info on what specific service pack/patch level of Oracle 8i I'm running?

"Bert Bear" <bertbear_at_NOSPAMbertbear.net> wrote in message news:bFe3a.179$nk2.97284257_at_newssvr11.news.prodigy.com...
> 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)?"
>
> Bertram Moshier
> Oracle Certified Professional 8i and 9i DBA
>
> 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:44:59 CET

Original text of this message