DBMS_OUTPUT.PUT_LINE

From: Gordon E. Hooker <gordonh_at_acslink.net.au>
Date: 1995/10/24
Message-ID: <46ibim$f10_at_peg.apc.org>#1/1

        chuckh_at_ix.netcom.com (Chuck Hamilton) wrote:

>kskelton_at_earth.execpc.com (Kevin Skelton) wrote:
 

>>Hi, I am successfully using the PUT_Line statement in my sql*plus scripts
>>to print out variables from stored procedures.
 

>Is there something special you need to do to get it to work? I've
>tried it in the past. The procedures ran without errors but never
>displayed any output. I'm on versions 7.1.6 and 7.1.3. Got the same
>result with both.

All you have to do is;

in sqlplus

SQL > set server output on

that will do the trick.

>Chuck Hamilton
>chuckh_at_ix.netcom.com
 

>Incoming fire has the right of way!

-----------------------------\ooOoo/-----------------------------------
Gordon Hooker MACS PCP                                     ,--_|\
25 Clarke Street, Ripley, Queensland, 4306, Australia     /      \ 
gordonh_at_acslink.net.au                                    \_.--._/
mobile: 018883835 phone: 61-7-2889716                           V
-----------------------------------------------------------------------

It is far better to remain silent and appear a fool, than to open ones mouth and remove all doubt... Received on Tue Oct 24 1995 - 00:00:00 CET