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: how to print something in PL/SQL?

Re: how to print something in PL/SQL?

From: Michael Rothwell <marothwell_at_yahoo.com>
Date: Fri, 21 Jan 2000 09:58:24 -0800
Message-ID: <38889E40.DDBB6FA1@yahoo.com>


Dont forget to "set serveroutput on" in SQL*Plus and also, before using dbms_output.put_line you need to include the line dbms_output.enable( 1000 ) or some other size .

Michael

Emmanuel HUMBLOT wrote:

> use dbms_output.put_line procedure.
>
> example :
>
> set serveroutput on
>
> begin
> dbms_output.put_line('this line will print');
> end;
> /
>
> --
> Regards
>
> Emmanuel HUMBLOT e_humblot_at_wanadoo.fr
>
> Jeff <kit_at_cintec.cuhk.edu.hk> a écrit dans l'article
> <867dfk$e4d$1_at_justice.csc.cuhk.edu.hk>...
> > Hi,
> >
> > How do you print something in stdout in PL/SQL?
> > Does 'prompt' work?
> >
> > Jeff
> >
> >
> >
Received on Fri Jan 21 2000 - 11:58:24 CST

Original text of this message

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