Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: stored procedure
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
![]() |
![]() |