Re: DBMS_OUTPUT where ?
From: Balakrishna Avula <100610.52_at_compuserve.com>
Date: 1996/03/27
Message-ID: <4jbtqf$69e_at_relay2.uk.mdis.com>#1/1
Date: 1996/03/27
Message-ID: <4jbtqf$69e_at_relay2.uk.mdis.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.
>Thanks, BOB.
>Connected to:
>Oracle7 Server Release 7.2.2.3.0 - Production Release
>PL/SQL Release 2.2.2.3.0 - Production
>SQL> begin
> 2 dbms_output.enable;
> 3 dbms_output.put_line ('test');
> 4 end;
> 5 /
>PL/SQL procedure successfully completed.
>SQL>
>(ok - so where's the output ?)
>
Set serveroutput on
before you execute pl/sql block
-- Balakrishna Avula 28 Ashby Court Alpha-Tek Associates Ltd. Hemel Hempstead Technical Consultant HERTS HP2 7QL 100610,52 on Compuserve UK http://ourworld.compuserve.com/homepages/BAvula/homepage.htm on WWWReceived on Wed Mar 27 1996 - 00:00:00 CET