Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: dbms_output statements print after executing WHY?

Re: dbms_output statements print after executing WHY?

From: Frank van Bortel <f.van.bortel_at_vnl.nl>
Date: 2000/03/07
Message-ID: <38C5801B.92D15F7C@vnl.nl>#1/1

Sybrand Bakker wrote:

> Because the output is buffered. It will not print until the first buffer is
> flushed. There seems to be a dbms_debug package now. I never used that, but
> you would expect that would work differently.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> anurag <aminochaNOamSPAM_at_unibiz.com.invalid> wrote in message
> news:0a2889cc.07cf71b8_at_usw-ex0105-034.remarq.com...
> > Hi,
> > I was wondering why does pl/sql print the dbms_output statements
> > after executing the procedure. why cannot it work like any other
> > language and make our lifes easy.
> >
> > Thanks
> > Anurag
> >
> >
> >
> >
> > * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
 *
> > The fastest and easiest way to search and participate in Usenet - Free!
> >

Or use DBMS_PIPE...

--
Met vriendelijke groet/kind regards,

Frank van Bortel
Technical consultant Oracle
Received on Tue Mar 07 2000 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US