Re: newbie having woes with dbms_output in functions

sean nakasone schrieb:
> 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

Could you read again the answer given you by William Robertson?

Best regards

Maxim Received on Thu Mar 01 2007 - 15:53:54 CST