Re: set command in PL-SQL

dbms_output.enable(buffersize) ...

"Fidelio" <rjn_at_pobox.com> wrote in message news:8p5cef$4vm$1_at_xs4.xs4all.nl...
> "Emre Akbag" <akbag_at_scr.siemens.com> writes:
>
> >How can I run "set serveroutput on" command in a stored procedure?
> >Or where can I find the parameter file for SQL-Plus, where I can set
 these
> >kind of parameters globally?
> >I hope, there is such a file.
>
> set serveroutput on is a SQL*Plus command, not sql or pl/sql.
> PL/SQL runs on the server, and if you use dmbs_output.put_line()
> you send output to the client calling the pl/sql. Some clients,
> like SLQ*Plus ignore this output when setrveroutput is off, and
> will display it when serveroutput is on. Other client tools
> may fetch it by default, or ignore it. There is no way of knowing
> when using pl/sql.
>
> R
>
> --
> Get tons of referrals - Sign up now ! http://www.refmatrix.com/
> The Adsenger information resource -

http://www.xs4all.nl/~rob/adsenger.html Received on Wed Sep 06 2000 - 19:07:46 CDT