Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: DBMS_OUTPUT.PUT_LINE from within a function.

Re: DBMS_OUTPUT.PUT_LINE from within a function.

From: Jeff Bailey <sasxjb_at_wnt.sas.com>
Date: Fri, 18 Aug 2000 09:08:17 -0400
Message-ID: <6TSdOfHxZdb0xWU1C1y4b55gT2gI@4ax.com>

On Fri, 18 Aug 2000 10:17:33 +0900, "Yong" <yk-park_at_fkl.fujitsu.co.kr> wrote:

>set serveroutput on
>
>( parameter need to fixed "on", the default value is "off" )
>

I did that. I am trying to get it to display output during a select statement and I think that it may be impossible...

I changed it to a procedure and can now at least see what it is doing...

Thanks for the help,
Jeff

>
>
>Jeff Bailey <sasxjb_at_wnt.sas.com>ÀÌ(°¡) ¾Æ·¡ ¸Þ½ÃÁö¸¦
>news:yOGbOeO46JCHFFznwNZTcC81Qaij_at_4ax.com¿¡ °Ô½ÃÇÏ¿´½À´Ï´Ù.
>> Hi,
>>
>> I may be missing something here. Can DBMS_OUTPUT.PUT_LINE be used
>> successfully within a function? I have used it often within a
>> procedure but cannot seem to get it to work with a function.
>>
>> Thanks,
>> Jeff Bailey
>>
>> Jeff.Bailey_at_sas.com
>
  Received on Fri Aug 18 2000 - 08:08:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US