Re: HELP: Output from within Stored Procedure

In <4motps$59r_at_newsbf02.news.aol.com>, ahoff54565_at_aol.com (AHoff54565) writes:
>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.

Is it possible to include the session command (serveroutput on) in the PL/SQL routine so the user doesn't have to issue it each time? Thanks,
Bruce Copping Received on Sat Jun 01 1996 - 00:00:00 CEST