Re: DBMS_OUTPUT problem

From: Gerrit-Jan Linker <linker_at_oraxcel.com>
Date: 2000/04/08
Message-ID: <8cnj0k$rkp$5@news5.svr.pol.co.uk>#1/1

It's a good habit to put set serveroutput on at the start of a sql file. You probably were going to save your file I presume. If you issue a set serveroutput on statement before your query you ensure that the results will be displayed.

Regards,

--
Gerrit-Jan Linker

web:     http://www.oraxcel.com
email:  gjlinker_at_oraxcel.com

Oraxcel: Linking Oracle to Excel
OraCodes: Explaining ORA- error codes
OraSQL: Explaining Oracle SQL syntax
OraDebug: PL/SQL debugger
OraWeb: Oracle access from IE

marketmaker <wensheng_98NOweSPAM_at_yahoo.com.invalid> wrote in message
news:21c6095c.1e0b1fc2_at_usw-ex0102-084.remarq.com...


> I was writing the following plsql code under Oracle8i and got no

> output message. Can anyone tell me what went wrong?  Thanks a

> lot!

>

> SQL> begin

>   2  dbms_output.enable();

>   3  dbms_output.put_line('sdaf');

>   4  end;

>   5  /

>

> PL/SQL procedure successfully completed.

>

> mm

>

>

> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network

 *


> The fastest and easiest way to search and participate in Usenet - Free!

>

Received on Sat Apr 08 2000 - 00:00:00 CDT