Re: Help with DBMS_OUTPUT

Steve Newhouse wrote:
>
> godzilla_at_seuss.cc.utexas.edu (Jim Lyons) wrote:
 

> >begin
> > DBMS_OUTPUT.PUT_LINE ('hello, world!');
> >end;
 

> Add to the beginning of the PL/SQL procedure:
> DBMS_OUTPUT.ENABLE();
fyi,
  my testing shows that you must also enable the output using  set serveroutput on

in sqlplus or sqldba, before running the pl/sql block.

see O7 Server Applications Developers Guide, A-25.

phil

-- 
Philip Fielder     YellNet 505.665.3227     Fac. for Info.,Management,
EES-5/MS D452      FaxNet  505.667.1628     Analysis and Display
FIMAD/Los Alamos Nat. Lab	 	           
Los Alamos, NM 87545                   URL : http://ees.lanl.gov/fimad