Re: DBMS_OUTPUT where ?
From: Ian Cary <I.Cary_at_cityscape.co.uk>
Date: 1996/03/26
Message-ID: <4j9s44$a5k_at_news.cityscape.co.uk>#1/1
Date: 1996/03/26
Message-ID: <4j9s44$a5k_at_news.cityscape.co.uk>#1/1
In article <NEWTNews.827805469.640.bevans_at_bje.avl.com>, bevans_at_pinpoint.avl.com says:
>
>
>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 -- (This should solve your problem)
Received on Tue Mar 26 1996 - 00:00:00 CET