Re: newbie having woes with dbms_output in functions

From: sean nakasone <seannakasone_at_yahoo.com>
Date: Thu, 1 Mar 2007 15:49:16 -1000
Message-ID: <Pine.WNT.4.64.0703011546180.1724@pgsnakason.hawaiianelectric.net>

Where do I put the exec null? I tried this but it still does not output 'hello'. see below.

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> select seanFunc1('the') from dual;

SEANFUNC1('THE')

---

at the end

SQL> exec null;

PL/SQL procedure successfully completed.

SQL> Received on Thu Mar 01 2007 - 19:49:16 CST