Re: DBMS_OUTPUT where ?

From: Richard Bennett <richhb_at_sequent.com>
Date: 1996/04/03
Message-ID: <3162D155.692F_at_sequent.com>#1/1


bevans_at_pinpoint.avl.com wrote:
>
> I'm new at PL/SQL.
> Why doesn't the following produce any output ?
> I'm logged is as SYS.
> SQL> begin
> 2 dbms_output.enable;
> 3 dbms_output.put_line ('test');
> 4 end;
> 5 /
> (ok - so where's the output ?)
>

Turn on the Server output before using dbms_output.put_line: SQL> set serveroutput on

I hope this helps

-- 
===============================================================
Richard Bennett		E-Mail: richhb_at_sequent.com
				rbennett_at_teleport.com
Computer People Inc.	On contract to Sequent Computer Systems
Received on Wed Apr 03 1996 - 00:00:00 CEST

Original text of this message