Re: stored procedure

From: Vladimir M. Zakharychev <bob_at_dpsp-yes.com>
Date: Mon, 23 Sep 2002 12:56:40 +0400
Message-ID: <amml35$sgn$1@babylon.agtel.net>

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.

-- 
Vladimir Zakharychev (bob@dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.


"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?

> 

> "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 - 03:56:40 CDT