So that means if i don't set serveroutput on, the output will go nowhere
and is just discarded?
"Guido Konsolke" <gk61_at_gmx.net> wrote in message
news:1032765711.8510_at_news.thyssen.com...
> "xueyang" <xueyangy_at_singnet.com.sg> wrote...
> > Hi,
> >
> > One question, If i use dbms_output.put_line in a stored procedure, where
i
> > can find the output?
> >
> > Thanks in advance.
> >
> Hi,
> just use something like 'SET SERVEROUTPUT ON SIZE 100000'
> in the session that will call the stored procedure. After that, execute
> the procedure. The output will come up when the procedure comes
> to end.
>
> hth,
> Guido
>
>
>
Received on Mon Sep 23 2002 - 02:36:41 CDT
