Re: DBMS_OUTPUT questions

"Code Monkee" <monkee_at_monkeebusiness.com> wrote in message news:<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?
>

If you are running these procedures from sqlplus, in the output. You can't see DBMS_OUTPUT messages if you run procedures different way. I this case, you need to use different way to print debug messages, for example, using DBMS_PIPE.

> 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 Mon Feb 17 2003 - 17:56:17 CET