From: Richard Woods <rawoods@concentric.net>
Subject: Re: PL/SQL -- a mute?
Date: 1996/08/08
Message-ID: <320A6B17.1E8E@concentric.net>#1/1
references: <01bb852f$922695e0$95f9210a@jlent3>
content-type: text/plain; charset=us-ascii
organization: Oracle Corporation
mime-version: 1.0
newsgroups: comp.databases.oracle
x-mailer: Mozilla 2.01 (Win16; U)



Jonathan Lent wrote:
> 
> Somebody please confirm this:  PL/SQL has no way of getting output to the
> standard output device without using some other application to print the
> output.  Having used Sybase's Transact SQL (although I don't particularly
> like Sybase), I'm a little floored that there aren't any basic output
> commands in PL/SQL.  I know I could write a SQL*Plus script, but it seems a
> little kludgy.  Any comments or advice?
> 
> --
> Respectfully,
> 
> Jonathan Lent
> [ All statements are mine alone ]Jonathan,

There's a PL/SQL package called DBMS_OUTPUT that is described in 
$ORACLE_HOME/rdbms/admin/dbmsotpt.sql that provides the functionality 
you're looking for.
-- 
Rich Woods, Field Support Analyst 
Oracle Corporation, USA
The comments and opinions expressed herein are mine and 
do not necessarily represent those of Oracle Corporation.