Re: DBMS_OUTPUT where ?

From: AMARENDRA B NETTEM <nettama_at_charlie.acc.iit.edu>
Date: 1996/03/26
Message-ID: <3158089B.5109_at_charlie.acc.iit.edu>#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 ?)
> before running the PL/SQL script..
"set serveroutput on" at the SQL prompt
and then run the above script.
Hope this helps

AMARENDRA

	AMARENDRA B NETTEM
        PH.No. (312)945-2116
        HOMEPAGE:  http://www.iit.edu/~nettama
	E-MAIL  :  nettama_at_charlie.acc.iit.edu
Received on Tue Mar 26 1996 - 00:00:00 CET

Original text of this message