Re: DBMS_OUTPUT questions

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

Try this link. Remove fnd_file call from send_msg procedure.

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&threadm=336da121.0211262043.5257a9ec%40posting.google.com&rnum=38&prev=/groups%3Fq%3Dfilonov%2Bgroup:comp.databases.oracle.*%26hl%3Den%26lr%3D%26ie%3DUTF-8%26scoring%3Dd%26start%3D30%26sa%3DN

If link doesn't work for you, google by keywords "filonov jdbc dbms_pipe",
or ask me to repost it.

> "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 Tue Feb 18 2003 - 18:20:56 CET