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

Home -> Community -> Usenet -> c.d.o.misc -> Re: newbie having woes with dbms_output in functions

Re: newbie having woes with dbms_output in functions

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 26 Feb 2007 17:19:28 -0800
Message-ID: <1172539166.702439@bubbleator.drizzle.com>


Anurag Varma wrote:

> On Feb 26, 4:22 pm, sean nakasone <seannakas..._at_yahoo.com> wrote:

>> Hello,
>>
>> I have the following function:
>>
>> create or replace function seanFunc1(val varchar2)
>> return varchar2 is
>> begin
>> dbms_output.enable(1000000);
>> dbms_output.put_line('hello');
>> return 'at the end';
>> end;
>> /
>>
>> When I call this function from the sqlplus command line, it does not print
>> 'hello'.
>> i.e.
>> select seanFunc1('the') from dual;
>>
>> But when I call the function in a code block as shown below, it then
>> prints.
>>
>> declare
>> var varchar2(50);
>> begin
>> select seanFunc1('the') into var from dual;
>> end;
>> /
>>
>> Why is this? What's the simplest way to get output from a function?
> 
> 
> In sqlplus you should issue
> 
> set serveroutput on size <nnnnnnn>
> 
> (e.g. set serveroutput on size 100000)

This is now version dependent and not required in 10gR2.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Mon Feb 26 2007 - 19:19:28 CST

Original text of this message

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