Re: PL/SQL -- a mute?

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.