RE: DBMS_OUTPUT

David

> SQL> set serveroutput on;
> SQL> show serveroutput;
> serveroutput ON size 2000 format WORD_WRAPPED
> SQL> create or replace function test return number is begin
> DBMS_OUTPUT.put_line('Hello, world!'); return 0; end;
> 2 /
>
> Function created.
>
> SQL> select test() from dual;
>
> TEST()
> ----------
> 0
>
> SQL>
This is the "old" behavior. As of SQL*Plus 10gR1 it works as expected...

HTH
Chris

--
http://www.freelists.org/webpage/oracle-l