Home -> Usenet -> comp.databases.oracle -> Re: HELP: Output from within Stored Procedure

Re: HELP: Output from within Stored Procedure

From: AHoff54565 <ahoff54565_at_aol.com>
Date: 1996/05/07
Message-ID: <4motps$59r_at_newsbf02.news.aol.com>#1/1 








Hello,



There is a system package called DBMS_OUTPUT.PUT_LINE which outputs data
from within a PL/SQL routine.  You need to SET SERVEROUTPUT ON in your
SQL*PLUS session in order for this to work.  



Example:



BEGIN


DBMS_OUTPUT.PUT_LINE('hello world');  <---output to screen



END;


This package can display text and variables.  Also, in SQL*PLUS routines
you can spool output using the spool <file name> command before the select
statement.  Good Luck.
Received on Tue May 07 1996 - 00:00:00 CEST












Original text of this message