Re: DBMS_OUTPUT
From: Richard Bennett <richhb_at_sequent.com>
Date: 1996/03/21
Message-ID: <3151AF38.655E_at_sequent.com>#1/1
Date: 1996/03/21
Message-ID: <3151AF38.655E_at_sequent.com>#1/1
Jeff Page wrote:
>
> I'm using Oracle Workgroup Server [v.7.1] and sql*plus [v.3.1]
> on NT 3.50. I sucesssfully compiled the dbms_output package [as
> user sys] but when I execute any test procedure in sql*plus,
> put_line does not display any output. Have I missed a step? Does
> the package, in fact, work on my platform?
>
> Any feedback will be greatly appreciated.
>
> Jeff Page
You need to type 'set serveroutput on' Before you run your PL/SQL statement with the dbms_output.put_line command.
Hope this helps.
-- =============================================================== Richard Bennett E-Mail: richhb_at_sequent.com 73501.1703_at_compuserve.com Computer People Inc. On contract to Sequent Computer SystemsReceived on Thu Mar 21 1996 - 00:00:00 CET