Re: newbie having woes with dbms_output in functions

From: sean nakasone <seannakasone_at_yahoo.com>
Date: Thu, 1 Mar 2007 11:42:00 -1000
Message-ID: <Pine.WNT.4.64.0703011139160.3688@pgsnakason.hawaiianelectric.net>

Even with 'set serveroutput on' it does not print 'hello', it only prints 'at the end'.

I'm using oracle 9.2. Here's a cut and paste from my sqlplus console.

SQL> set serveroutput on
SQL> create or replace function seanFunc1(val varchar2)

   2 return varchar2 is
   3 begin

   4      dbms_output.enable(1000000);
   5      dbms_output.put_line('hello');
   6      return 'at the end';

   7 end;
   8 /

Function created.

SQL>
SQL>
SQL> select seanFunc1('the') from dual;

at the end Received on Thu Mar 01 2007 - 15:42:00 CST