Re: DBMS_OUTPUT questions

DBMS_PIPE? I'm intrigued.
Can you tell me more about how to use this, or point me to an online source describing its usage?

Thanks

"Alex Filonov" <afilonov_at_yahoo.com> wrote in message news:336da121.0302170856.9651d2a_at_posting.google.com...
> "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 - 18:56:24 CET