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: stored procedure

Re: stored procedure

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Mon, 23 Sep 2002 21:43:41 +0100
Message-ID: <3d8f8963_3@mk-nntp-1.news.uk.worldonline.com>


IIRC, it sometimes it turns up in the alert log. I'm checking to see under what circumstances.
Please *don't* take this as reliable; I'll report back.

HTH,
Paul

"Guido Konsolke" <gk61_at_gmx.net> wrote in message news:1032776722.318731_at_news.thyssen.com...
> Hi Vladimir,
>
> thanks for helping, I couldn't answer in time (boring meeting...).
>
> Greetings,
> Guido
>
> "Vladimir M. Zakharychev" wrote...
> > No, it's still cached in dbms_output buffer. To see "lost" output,
> >
> > set serveroutput on size <whatever>
> > exec null
> >
> > in the same session and SQL*Plus will read what's there in the buffer
> > and print it. But as soon as you disconnect, the output is gone.
> > "xueyang" <xueyangy_at_singnet.com.sg> wrote in message
> news:ammg3f$opb$1_at_mawar.singnet.com.sg...
> > > So that means if i don't set serveroutput on, the output will go
> nowhere
> > > and is just discarded?
> > >
>
>
>
Received on Mon Sep 23 2002 - 15:43:41 CDT

Original text of this message

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